I have tried to password protect my workbook to disallow everything except editing assumptions cells but I was still able to un-hide sheets by right-clicking on the tabs menu - does anyone know how to correct this?
I have tried to password protect my workbook to disallow everything except editing assumptions cells but I was still able to un-hide sheets by right-clicking on the tabs menu - does anyone know how to correct this?
Hi Tarjei, the screenshot you posted above indicates that you allowed the Hide and Unhide sheets. The checkboxes select the items that you "Allow users of this modular workbook", so try and deselect the item highlighted in yellow and let us know if you still have issues.
Delia.
Hi Delia,
How embarrassing - I've allowed everything except for editing assumptions, ha ha.
Thank you for pointing that out!
Cheers
T
Going hard on protection there Tarjei haha.