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.
|