+ Reply to Thread
Results 1 to 2 of 2

Protection and hidden sheets

  1. #1
    Registered User
    Join Date
    06-01-2006
    Posts
    36

    Protection and hidden sheets

    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.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    1. How does a user navigate between sheets with keystrokes (on accident in this case)? Is there a way to prevent this?
    With non-hidden sheets, you can move between them using CTRL+PAGEDOWN or PAGEUP. I'm not aware of how to accidentally land on a hidden sheet using keystrokes. If you want hidden sheets to stay hidden, you can hide them and then protect the workbook/structure. You don't need to protect the individual worksheets if your goal is just to keep sheets hidden. (The other way would be to use vba to make the sheets you want to hide "xlVeryHidden".)

    2. Is there a way to protect the preferences on the worksheet so they can not be changed?
    You can protect worksheets using the Tools menu (Protection-->Protect Sheets). This will stop users from changing formats and any locked cells. If you want users to be able to edit parts of the worksheets while protected, make sure you unlock them first. (Format--Cells...--Protection --Uncheck 'Locked')

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1