LinkBack URL
About LinkBacks
I have a button that performs a macro to clear cells on a sheet. I am wondering if it is possible to put rules on the use of the button so it can't be pressed once by accident and erase everything
I have a button that performs a macro to clear cells on a sheet. I am wondering if it is possible to put rules on the use of the button so it can't be pressed once by accident and erase everything
maybe something like
Please Login or Register to view this content.
Another idea is to remove the button. You can run a macro using the ALT-F8 macro list.
Even better is if you macro doesn't appear in that list, you can still run the macro by typing its hidden name in the RUN box in the ALT-F8 macro list window. So only you know the real name of the hidden macro and can thus run it.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Where would I put this? Within the macro itself?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks