I have an excel file with macros running thru the entire workbook. When I protect the workbook all macros stop running. Can anyone help? I want protect the workbook and only allow users to enter data in certain required fields.
Please Login or Register to view this content.
Last edited by JBeaucaire; 01-26-2013 at 02:20 PM. Reason: Added code tags, as per forum rules. Don't forget!
Your macro will need to
1) Unprotect the sheet
2) Turn off all self-activating macros temporarily
3) Do it's stuff
4) Protect the sheet again
5) Turn other macros back on
Please Login or Register to view this content.
I've also added a much shorter syntax for hiding/unhiding rows with single lines of code that act light light switches.
_________________
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!)
Not sure what I'm doing wrong but it still does not work. Attached is the document I'm trying to protect.
Not sure what you want us to do with a file completely locked down that way and no instructions...
Sorry not sure why the file didn't open for you. I re attached the file.
I can view the file just fine, but you're posting a locked file.
http://screencast.com/t/QhHcxOrk
That's so weird. I tried opening the file that was uploaded and its locked. Just sent the file to your email address. Something is affecting the file when it is uploaded. I don't have any lock on the file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks