Del Hide Display

Hi expert,

Need to use this code for all users for all workbook - all sheets via quick access tool bar.

see attached file.



Thanks
Error-Remove.xlsm
LVL 8
Naresh PatelTraderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Naresh PatelTraderAuthor Commented:
One more thing i want to protect the code by PassWord & while deleting button it create copy of sheet in same workbook with its actual formula. it is just for ,in case accidently click on delete tool bar.
0
gowflowCommented:
ok no problem for the password
As for creating a copy I am afaird that this may be too cumbersome if each time a user click on delete you may endup with a lot of copies of formulas in case .... I think in my mind we can do the following:

When the user as to remove formulas then,
1) We ask for a confirmation question ... something like Are you sure you want to delete ... ?
2) Then we can built an Audit sheet and there put what we are deleting not a simple copy of the worksheet.

PLs confirm you want me to go this way or else pls comment.
gowflow
0
Naresh PatelTraderAuthor Commented:
Yes it sounds more logical......
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

gowflowCommented:
ok fine test this. Still the password which is no sweat will do at the end.

After you run it go at the Add-in menu and check the menu there. Check deletions in Audit sheet.

Let me know
gowflow
Err-Rem-Hid-Show-V01.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Naresh PatelTraderAuthor Commented:
thumbs Up   perfect...!!!!
0
Naresh PatelTraderAuthor Commented:
Now password & make every one on this pc use this feature.
0
Naresh PatelTraderAuthor Commented:
ok Sir gowflow password protected done by my self, make it global add in done only one thing in each & every time start up there is message box which is not requirednot Required


Thanks
0
gowflowCommented:
Well comment out this on the Module mAddmenus
MsgBox ("Menu created in Add-In Tab")

put a single quote ' at the very beginning it will turn Green then it will not execute this instructions. Save the workbook after you do this.

gowflow
0
Naresh PatelTraderAuthor Commented:
Sir will you give me some time to test as i am off the desk...


thanks
0
gowflowCommented:
for sure. I am also off for sometime. see u later.
gowflow
0
Naresh PatelTraderAuthor Commented:
Apology for late in reply from my side.

I had tested working fine.

For Password - this things done - VBA Window - Tools - Project properties - Protection - Lock Project.

For every one use save as Excel Add-In which saves file in Microsoft AddIn Folder.

is that right thing I had done?


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

Rest all working fine

Thanks
0
gowflowCommented:
yes for sure you went too fast. I gave you the solution with the menu but still it is not adapted to work as an addin we need to change things around. For the addin we need to set it up differently. I suggest you post a new question and will deal with at separately.
gowflow
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.