Protected Sheets

Password Protected Sheet

Hi,

I have been working on a workbook that contains Macro for hiding columns with Modano active. 

I understand that Modano has password protection to prevent unwanted changes in the formula and formats but this has caused my code to break every time I re-open the workbook.

Is there any way to get around this without releasing the workbook?

Attached is a screenshot of the error that I got every time I run the code right after I open the workbook. 

Thanks

Unprotecting multiple non-freeform sheets

Hi Modano

I saved the view of my model before sending it to a partner of mine, however he is unable to unprotect certain sheets in the model because they're non-freeform.

I tried to unprotect multiple sheets, but I got the following error message.

Am I missing something or is there a workaround?

Simon

Subscribe to RSS - Protected Sheets