Checking If A Workbook Is Read Only

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Checking If A Workbook Is Read Only

  1. #1
    Board Regular
    Join Date
    May 2002
    Location
    San Diego
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Checking If A Workbook Is Read Only

     
    I have a workbook that is used by several people. I'd like to check, upon opening, if the workbook was opened Read Only because someone else is in it. If the workbook is opened Read Only, I want to popup a message telling the user to try again later.

    I struck out seraching the site. Is there a way to check if a workbook was opened as Read Only?

    Thanks for any assistance!

    Mark

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Posts
    113
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Checking If A Workbook Is Read Only

    If ActiveWorkbook.ReadOnly Then.....

  3. #3
    Board Regular
    Join Date
    May 2002
    Location
    San Diego
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Checking If A Workbook Is Read Only

      
    That's perfect! I can't believe it was so simple.

    Thank you very much!

    M

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com