Events for the worksheet object occurs when a worksheet is activated or the user changes the content of a cell. Events in worksheets are activated by default, but can be deactivated by a macro. To display the event procedures for … Continue reading
Events for the worksheet object occurs when a worksheet is activated or the user changes the content of a cell. Events in worksheets are activated by default, but can be deactivated by a macro. To display the event procedures for … Continue reading
Events for the Workbook object occurs when the workbook is changed or a sheet in the workbook is changed. Events in workbooks are activated by default, but can be deactivated by a macro. To display the event procedures for a … Continue reading
If you wish to open a workbook without running an Auto_Open-macro, you can do this by holding the Shift-key down when you open the file. If the workbook is password protected, remember to hold the Shift-key down after you have … Continue reading
If you want to write event procedures for an embedded chart, you will have to create a class module to do this: Start the Visual Basic editor. Select the desired project in the Project-window. Insert a new class module by … Continue reading
Start the Visual Basic editor. Select the desired project in the Project-window. Insert a new class module by selecting the menu Insert | Class Module. Activate the new class module and rename it, e.g. AppEventClass Copy and paste these example … Continue reading
