Locking Navigation Between Worksheets

[nutrageousd]

Hi All,

Does anybody know if there is a way to prevent a user from navigating between worksheets by clicking the tabs at the bottom? I have a workbook that has "Next" and "Back" buttons to jump between worksheets, and I want to prevent users from being able to over ride it by clicking the tabs. (I have a macro to check that they fill out all necessary fields)

Thanks in advance!

 

[Smitty]

Just hide the tabs.

In Excel 2007 it's Office Button-->Advanced-->Display options for this workbook-->Uncheck Show sheet tabs. For earlier versions goto Tools-->Options.

Note that's not going to stop CTRL+Page Up/Down navigation.

HTH,

 

[nutrageousd]

Thanks for the quick reply Smitty! Appreciate it!

 

[tusharm]

Instead of disabling native capabilities enhance your code to guide people to the correct worksheet if they jump to the wrong one.

Hi All,

Does anybody know if there is a way to prevent a user from navigating between worksheets by clicking the tabs at the bottom? I have a workbook that has "Next" and "Back" buttons to jump between worksheets, and I want to prevent users from being able to over ride it by clicking the tabs. (I have a macro to check that they fill out all necessary fields)

Thanks in advance!

 

[Smitty]

Instead of disabling native capabilities enhance your code to guide people to the correct worksheet if they jump to the wrong one.

I think you're giving end users far too much credit.

But to Tushar's point, any native feature you disable should also be re-enabled when you're done, otherwise you'll have upset users.