Prompt a message if "Read Only"

[jp16]

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]

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

Please Login or Register  to view this content.