Prompt a message if "Read Only"

**jp16** · 10-08-2018, 12:19 AM

Hi, lets say if i have a path that link to a specific excel in a Shared Folder.

How do i make it that if the Excel is "read only" (meaning, another user is using it), it prompt a message saying "File is being use, please try again later" then exit sub.

**pjwhitfield** · 10-08-2018, 05:45 AM

I believe there's a check for it as part of the Workbook object

if(wb.ReadOnly) then
       msgbox "........."

Prompt a message if "Read Only"

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Prompt a message if "Read Only"

Re: Prompt a message if "Read Only"

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] I receive the message, "Unable to Read File" when I click on an Excel icon

if data file is opened as read only, then the macro gives an "error" message

[SOLVED] Opening Read-Only from Sharepoint causes "Save As" prompt

VBA. save Shared workbook. not to prompt "conflict" message if its to do with cell x,y,z

[SOLVED] "Unable to read file"message in Word & Excel

I am receiving a "unable to read file" message. How do I open?

Error message "Unable to read file"

Bookmarks

Bookmarks

Posting Permissions