Solved

AddIn

Posted on 2014-01-25
7
333 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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

This collection of functions covers all the normal rounding methods of just about any numeric value.
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

762 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

20 Experts available now in Live!

Get 1:1 Help Now