+ Reply to Thread
Results 1 to 3 of 3

Sheet Protection "select unlocked cells" doesn't repond the same between sheets

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2003
    Posts
    5

    Thumbs down Sheet Protection "select unlocked cells" doesn't repond the same between sheets

    XL '02

    In my workbook I have multiple sheets with generally 90% of the cells locked & hidden under sheet protection invoking "Select unlocked cells" [the only permission checked] . Most sheets allow cell highlight with selection, that's perfect.
    But, my primary sheet will allow cell selection [of unlocked cells] but will not highlight the cells. This sheet does have about 25 dropdowns from Control Toolbox with their underlying cells unlocked for proper function. The sheets providing cell highlights do not have any dropdowns. This is the only difference I can see between all the sheets.

    Anyone have a clue to why this is happening?

  2. #2
    Registered User
    Join Date
    06-21-2010
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Sheet Protection "select unlocked cells" doesn't repond the same between sheets

    I've partially resolved this myself with placing this code in the Workbook_Open Object Code File:

    It remedied the user permission to highlight the selected unlocked cells and to reinstate same permissions upon Save - Close - ReOpen, BUT, I've lost keyboard cell selection functions on the main sheet only. I must have a conflict on this main sheet somewhere. Time to dig into it.

    If anyone has any known or assumed conditions that can cause this I would appreciate any suggestions.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-21-2010
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2003
    Posts
    5

    New dilemma !

    My Workbook has 17 worksheets. Cell selection via mouse & keyboard function as they should for all but 1 sheet, my primary sheet. The primary sheet while protected & permitting "Select unlocked cells" will only allow cell selection via mouse it will not allow keyboard selections! It's a non issue with the other 16 sheets!

    I've gone over everything I can think of including the code within the sheet in question & the workbook code.

    Anyone have any previous experience with this or suggestions?

+ 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