• formula to show whether sheet is protected or not (xp)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » formula to show whether sheet is protected or not (xp)

    Author
    Topic
    WSMatz
    AskWoody Lounger
    January 11, 2008 at 11:15 am #447590

    HI

    I know you can use the =INFO(xxx) for various info to be displayed in a cell, such as the path of the location of the workbook, its size etc…

    Is there any formula to show whethe a sheet is protected or not?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      January 11, 2008 at 11:48 am #1092075

      I don’t think there is a built-in function for this. You could create a custom function:

      Function SheetProtected(oCell As Range) As Boolean
      Application.Volatile
      SheetProtected = oCell.Parent.ProtectContents
      End Function

      Use like this:

      =SheetProtected(A1)

      if you want to know if the active sheet is protected, or

      =SheetProtected(OtherSheet!A1)

      if you want to know if OtherSheet is protected.

      Reply | Quote
      • WSMatz
        AskWoody Lounger
        January 11, 2008 at 11:56 am #1092076

        Thought not either – thanks for the idea of making a custom function thats better than the vba sub i did

        Reply | Quote
    Viewing 0 reply threads
    Reply To: formula to show whether sheet is protected or not (xp)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.