+ Reply to Thread
Results 1 to 2 of 2

Unprotecting sheet keeps reverting back to protected mode

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    Chicago ⇄ L.A.
    MS-Off Ver
    365
    Posts
    30

    Unprotecting sheet keeps reverting back to protected mode

    I have a workbook that was created about a year ago which included buttons and macros to link to other pages (while the tabs were hidden) on a main "menu" sheet.

    On the main menu sheet, there are two buttons to the right, the first labeled "Add action plan" which copies an existing hidden sheet titled "action plan". This in turn asks what to name the sheet, and adds hyperlinks in cell G18, G19, G20, etc. (as you keep adding new action plans) in the main menu sheet.

    The second button is labeled "Delete Action plan" which deletes said copied sheets and the corresponding hyperlinks in G18, G19, G20 in the main sheet.

    This main menu sheet is protected but when I unprotect it (with password), add action plans (3 times to test), then delete action plans (3 times), it reverts the sheet back to PROTECTED. Why is this happening?

    Hope that makes sense.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,699

    Re: Unprotecting sheet keeps reverting back to protected mode

    There is no way to diagnose this without seeing your worksheets and all the code--can you attach the file?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Code for reverting cell format back to the original one
    By kairab in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2013, 01:14 AM
  2. Reverting back to original format when deselecting check box
    By achill3s in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2011, 11:14 PM
  3. Unprotecting sheet w/ workbook shared & Protected
    By ChemistB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2006, 01:06 PM
  4. Replies: 1
    Last Post: 10-12-2005, 05:05 PM
  5. Unable to open excel sheet in Protected mode from VB 6.0
    By ourspt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2005, 06:59 AM

Tags for this Thread

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