Solved

AddIn

Posted on 2014-01-25
7
343 Views
Last Modified: 2014-02-03
Hi expert,

Now issues while removing error messages from different workbook .it doesn't create Audit Sheet.

Previous Question

Rest all working fine.

Thanks
0
Comment
Question by:itjockey
  • 4
  • 3
7 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 39808688
What do you mean by:
Now issues while removing error messages from different workbook

??
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 39808947
Ok.ignore my post and start from where we stand in previous in question.
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 39809784
ok here it is and how it work:

1) You will need to delete all the addin you already created on all the PC's for your users and it is too bad but you went ahead and did this a bit too fast.
2) To do this on each machine first open Excel blank then choose Excel options then Addin then GO and unselect the addin you lined before that was:
Err-Rem-Hid-Show-V02
3) close the workbook then go to the user's folder then roaming then Microsoft/Addin and delete that file from there.
Err-Rem-Hid-Show-V02.xlsam
4) Save the below file in your directory as .xlsm
5) Open the file then save it as Addin .xlsam
6) close Excel
7) Open blank Excel and from Excel Options choose Addin and select this new file and tick it.
8) Close Excel
9) Now open any file and in the menu you have all 3 options and test it. if in the file you open it does not have the sheet Audit it will create it else if will add to it.

Let me know
gowlfow
Addin-Err-RHS-V03.xlsm
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 8

Author Closing Comment

by:itjockey
ID: 39811000
Perfect ....need to share one thing as I don't know anything  about Coding but it seems you sir, you are using some different kind of code. your code always work smoothly. i.e. flawless. is that my assumption right regarding you are using some different kind of Code or language?



Thank You Very Much
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39811288
Your welcome, thank you for your very nice appreciation. To answer your question, it is only experience that leads you to develop code that is well structured, but to say flawless ... well it need a lot still to reach that stage. We learn everyday !
Pls do not hesitate to put a link in here if you need more help on any other issue.
Regards/gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 39829445
Sir gowflow,

I just need to do some code modification in my this solved question Maths Final. will you pls look in to this. I am going to post new question for this. that is series of 2 question.


Thanks
0
 
LVL 8

Author Comment

by:itjockey
ID: 39829484
This the link for my new question Math New.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now