Locking options for a whole workbook

[thewilf]

Hello all,

Hopefully just a quick one. I am trying to figure out a way of password protecting the excel option to show/hide sheet tabs. Essentially I have a large number of sheets which all link to each other with macros and the user uses these to input data into a master data sheet.

I have written a line or two of code which removes sheet tabs when the workbook is opened and enabled them when closed (so it doesn't affect other workbooks). The thing is the user can just go to tool > options and then re-enable them. Is there anyway I can stop then from showing the tabs again while still having access to the sheet?

Cheers in advance.
Will

 

[Gerald Higgins]

Maybe not exactly what you were asking for, but how about hiding all the other sheets ?

 

[thewilf]

Hi,
I have hidden the sheet tabs but can't hide the sheets cause the user still needs to access them. It's just to stop users skipping ahead of the sequence I have set up by selecting other sheets. I didn't know if I could work some code to blank out the option or use an If statement that says if you select a sheet and sheet tabs are on it puts you back to another sheet (main menu) as an example?
Cheers
Will