?
Solved

AddIn

Posted on 2014-01-25
7
Medium Priority
?
385 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:Naresh Patel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 31

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:Naresh Patel
ID: 39808947
Ok.ignore my post and start from where we stand in previous in question.
0
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 8

Author Closing Comment

by:Naresh Patel
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 31

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:Naresh Patel
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:Naresh Patel
ID: 39829484
This the link for my new question Math New.
0

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

764 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