Thread: event procedure
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default event procedure

Hi GS,
Yeah, of course. D'uh. Thanks.
Regards - Dave.

"Gary''s Student" wrote:

Don't let the user save the file with that special worksheet active.

Use the Workbook BeforeSave event to move off the sheet (to an alternative
sheet) prior to saving. When the file is re-opened, it will open with the
alternative sheet active. The user will have to select the special sheet and
the worksheet activate event code will trigger.