View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
balexis balexis is offline
external usenet poster
 
Posts: 2
Default Is Workbook read-only because of file permission or because file is already opened?

Hi,

When someone opens my Excel workbook, I want to trap with VBA code
wether or not the file is read-only. Then, I want to do different
operations based on the cause of the read-only : file permissions are
read-only (or user does not have write permissions), or another user
already opened the file.

Is there a way to do such a distinction ?

Thank you very much in advance,


Alexis