I have a macro that protects all my worksheets. I have one tab that I unlocked some cells so that when it is protected the user can alter the contents. But everytime I protect the document using the macro the cells become locked again.
Do I have to write in the macro to unlock those cells prior to protecting it?
I have unlocked them, saved it. Then protected and it works, but if I use the macro to protect, then close the workbook and reopen the cells are locked again.
Help!
Do I have to write in the macro to unlock those cells prior to protecting it?
I have unlocked them, saved it. Then protected and it works, but if I use the macro to protect, then close the workbook and reopen the cells are locked again.
Help!