Excel VBA Programming For Dummies by Walkenbach John

Author:Walkenbach, John [Walkenbach, John]
Language: eng
Format: azw3, epub
ISBN: 9781119077442
Publisher: Wiley
Published: 2015-09-27T16:00:00+00:00

Workbook_SheetDeactivate: Executed when any sheet in the workbook is deactivated. It stores the sheet that is deactivated in an object variable — but only if the sheet is a worksheet. The Set keyword creates an object variable, which is available to all procedures in the module.

Workbook_SheetActivate: Executed when any sheet in the workbook is activated. It checks the type of sheet that is activated (using the TypeName function). If the sheet is a chart sheet, the user gets a message (see Figure 11-5). When the OK button in the message box is clicked, the previous worksheet (which is stored in the OldSheet variable) is reactivated.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.