Conditional enabling of menu items
OK I think I've got that working - but the xl_SheetDeactivate and
xl_SheetActivate get called when changing between tabs, but not when
closing or opening a workbook, or when focus moves off a cell and onto
a control (e.g. a button or an edit box). I need to work out which
events, if the necessary events are exposed.
Phil Hibbs.
|