Solved

AddIn

Posted on 2014-01-25
7
368 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
[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 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

749 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