Wonker
10-18-2007, 06:12 AM
Hello all,
As you know if you try to open a spreadsheet that is already open you are faced with the 'this is already open by blah blah' dialogue box, you are then given the opportunity to open as Read Only, Notify or Cancel. What I need, is to be able to tell if they have selected 'Notify' (basically, the way this system is set up the user should never use the notify option). I can identify if the spreadsheet is read only by using the command:
if ActiveWorkbook.ReadOnly = True
Is there something similar to identify that they have chosen the 'Notify' option. If I can trap this in the Workbook_Open() sub then I can do something about it.
Many thanks in advance
Paul Williams
As you know if you try to open a spreadsheet that is already open you are faced with the 'this is already open by blah blah' dialogue box, you are then given the opportunity to open as Read Only, Notify or Cancel. What I need, is to be able to tell if they have selected 'Notify' (basically, the way this system is set up the user should never use the notify option). I can identify if the spreadsheet is read only by using the command:
if ActiveWorkbook.ReadOnly = True
Is there something similar to identify that they have chosen the 'Notify' option. If I can trap this in the Workbook_Open() sub then I can do something about it.
Many thanks in advance
Paul Williams