I have a workboook that has three sheets.
Two of these are protected and hidden.
The third sheet is protected but has certain cells that can be amended by a third party. This third sheet also has a 'button' on it with a macro attached. Whilst in the protected mode, the macro will not run.
Is there any way around this without unprotecting the sheet?
I have realised that the macro is trying to adjust some of the protected cells so is the some code I can include in the macro that will unprotect the sheet and then re-protect it with the same password?
Bookmarks