VBA notes
VBA notes:
To view the macro assigned to a button on a worksheet, do the following 3 steps
1. Unprotect the worksheet
2. Enter the VBA project (if password protected)
3. On Developer Tab, turn on the “Design Mode”
4. Select the button of interest, right click mouse. There are 2 type of controls:
- Form Control: the pop up menu will show “Assign macro...”, click on it you will see the current assigned macro
- ActiveX Control: the pop up menu will show “View Code”, click on it you will see the click event of this button.
Note:
If the buttons (controls) which the macro assigned to is grouped, excel won’t show the macro name.
In order to see the assigned macro, you have to ungroup the controls first.
To view the macro assigned to a button on a worksheet, do the following 3 steps
1. Unprotect the worksheet
2. Enter the VBA project (if password protected)
3. On Developer Tab, turn on the “Design Mode”
4. Select the button of interest, right click mouse. There are 2 type of controls:
- Form Control: the pop up menu will show “Assign macro...”, click on it you will see the current assigned macro
- ActiveX Control: the pop up menu will show “View Code”, click on it you will see the click event of this button.
Note:
If the buttons (controls) which the macro assigned to is grouped, excel won’t show the macro name.
In order to see the assigned macro, you have to ungroup the controls first.
Comments
Post a Comment