Link to home
Start Free TrialLog in
Avatar of Naresh Patel
Naresh PatelFlag for India

asked on

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
Avatar of Naresh Patel
Naresh Patel
Flag of India image

ASKER

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.
Avatar of Jacques Geday
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
Yes it sounds more logical......
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thumbs Up   perfect...!!!!
Now password & make every one on this pc use this feature.
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 requiredUser generated image


Thanks
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
Sir will you give me some time to test as i am off the desk...


thanks
for sure. I am also off for sometime. see u later.
gowflow
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
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