Naresh Patel
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
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
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
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
ASKER
Yes it sounds more logical......
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thumbs Up perfect...!!!!
ASKER
Now password & make every one on this pc use this feature.
ASKER
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
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
ASKER
Sir will you give me some time to test as i am off the desk...
thanks
thanks
for sure. I am also off for sometime. see u later.
gowflow
gowflow
ASKER
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
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
gowflow
ASKER