I have a workbook which has about 7 worksheets. I have the password to the workbook, and when entered I want to be able to see all the worksheets and edit them without having to enter the password each time for individual sheets. However when I share the file and someone else opens it in 'Read-only' mode, I only want them to be able to see the first sheet, effectively hiding the other 6 sheets.
I cannot seem to find the right information on how to hide certain sheets in read only mode. I have looked into the 'very hidden' setting but that isn't based on whether I enter the password or not, I would still have to go into the VBA each time I wanted to see them.
Would greatly appreciate any help, cheers.
I cannot seem to find the right information on how to hide certain sheets in read only mode. I have looked into the 'very hidden' setting but that isn't based on whether I enter the password or not, I would still have to go into the VBA each time I wanted to see them.
Would greatly appreciate any help, cheers.
