How can a macro enter data in a protected Table cell?
I'm using this code to set a time-stamp in Table1 Column A2:A601, the column is protected. When i enter data in column B2:B601, the macro enters the time-stamp. However, if the sheet is protected (no password used) the macro throws an error. How can the macro be modified to function with the sheet Protected (no password)?
HTML Code:
Last edited by Mr.GfCs; 03-31-2016 at 06:03 PM. Reason: added file
I've added the spreadsheet to the post
This will test to see if the sheet is protected and return the sheet to the protection state it starts with. Assuming no password:
Please Login or Register to view this content.
_________________
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!)
Yes, that did it. Thanks again JBeaucaire. I'm an absolute novice when it comes to Excel formulas as I've never used it much. When I search for ways to do what I want, sometimes I understand it, mostly I don't. But I do try to resolve the issues before posting on this forum....
Thanks again.
Never apologize for asking for help on a forum dedicated to helping.
Glad to be of assistance. Pay it forward.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks