View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mick[_3_] Mick[_3_] is offline
external usenet poster
 
Posts: 14
Default If a Workbook is already open?

Hi

I have a macro that opens a workbook for the user to modify. However, I
need to stop the user from opening the workbook for a second time. I have
used the normal read only attribute which works to a degree, but if the user
chooses "No" I get an error in the macro. Also I don't want the user to be
able to say "Yes" and loose all the modifications made by opening the
workbook again.

--
Kind Regards

Mick