Allow Macro to Write into Protected Cell

**CRIMEDOG** · 08-19-2011, 09:42 AM

I have a macro that writes into cells I need protected - SO I made a macro:

Please Login or Register  to view this content.

This works great - But when I save the workbook, close it and open it again, if I don't re-run the macro, it won't allow the macro to write into the cell.

How do I make the change permanent, so the user doesn't have to run "ProtectOpen Macro"?

Thanks

**tigeravatar** · 08-19-2011, 10:00 AM

CRIMEDOG,

Give the following a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

**CRIMEDOG** · 08-19-2011, 10:03 AM

I thought about that - but if the setting UserInterfaceOnly would stay True - I wouldn't needto unprotect - then protect for every macro.

But you are probably right, thanks for the help.

**Kenneth Hobson** · 08-19-2011, 10:07 AM

Call your macro from the workbook's Open event.

e.g.
Doubleclick the ThisWorkBook object in the Project Explorer. If not open, View > Project Explorer. In the code window paste:

Please Login or Register  to view this content.

**CRIMEDOG** · 08-19-2011, 10:23 AM

Ok - I implemented it with a twist
I wrote it into a
WorkBook_Open() macro in the Workbook sheet.
Instead of Activesheet I used Worksheets("Sheet1").

Thanks for the idea - don't know why I didn't think about it.