Solved

AddIn

Posted on 2014-01-25
7
355 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

809 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