View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
McBarker McBarker is offline
external usenet poster
 
Posts: 7
Default Blocking a second spreadsheet from opening

I need help with line 3 of the following:

[1] Spreadsheet1 is already in use
[2] User opens Spreadsheet2 (from desktop shortcut - bypassing Excel menus)
[3] Code in the Spreadsheet2 Auto_Open() macro detects that Spreadsheet1 is
already open and in use
[4] A warning message is displayed
[5] Spreadsheet2 automatically closes

Regards
McBarker