I actually have 2 questions that are related--at least in my mind. I have a workbook with hidden sheets that are doing calculations for visible sheets. The sheet tabs are hidden, and users navigate between worksheets through hyperlinks. However, some users mistakenly jump to one of these hidden sheets by mistake.
So here are the questions:
1. How does a user navigate between sheets with keystrokes (on accident in this case)? Is there a way to prevent this?
2. Is there a way to protect the preferences on the worksheet so they can not be changed?
Thanks for any help you can provide.
Bookmarks