I'm hoping this is an easy answer.
I don't have the expertise in VBA to write a macro so I'm simply recording one.
However, as part of the macro sequence, the worksheet needs to be unprotected and then, before the macro finishes, it needs to be protected again.
I've tried a couple of different approaches; just clicking on "unprotect sheet" and typing in the password while recording the macro doesn't work. I tried storing the password in a hidden cell and then, as part of the macro, copying it and then pasting it in the "unprotect sheet" command.
Neither of these work - the macro simply hangs at the command line for the password when unprotecting the worksheet.
Is there a simple way past this problem?
Bookmarks