+ Reply to Thread
Results 1 to 3 of 3

Protection Mode...

Hybrid View

  1. #1
    Registered User
    Join Date
    02-15-2013
    Location
    Halesite, New York
    MS-Off Ver
    Excel 2010
    Posts
    39

    Protection Mode...

    Got a real stupid question....

    I have a sheet that is protected. I do not want to 'modify' the cell, but want to 'see' how the cell is created in the formula bar.

    Is there a way to do this???

    Thanks,

    Gary Harding
    Halesite NY

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,416

    Re: Protection Mode...

    If the worksheet has been protected using a password, then you will need to supply that password when you use Review | Unprotect Sheet.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    02-15-2013
    Location
    Halesite, New York
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Protection Mode...

    That I knew. All I wanted the ability to do, was not be able to 'change' the formula, but just to 'view' it.

    No worries, I will close this thread. Thanks!!!

+ 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. VBA Code Runs in Debug Mode But Returns Type Mismatch Error Outside Debug Mode
    By valerie.k.chiang in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2014, 03:48 PM
  2. [SOLVED] Code skips on Run Mode but runs fine on F8 (Debug Mode)
    By RaquelAR in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-25-2013, 01:05 PM
  3. Data List in sheet protection mode
    By scottb in forum Excel General
    Replies: 4
    Last Post: 05-13-2010, 04:10 AM
  4. Can I use VBA to check if the sheet(xxx) is in Page-Break mode or Normal mode ?
    By BaLLZaCH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2008, 09:03 AM
  5. Replies: 0
    Last Post: 01-07-2005, 04:06 PM

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