Info

Figure 24.9

Macros can be assigned to any drawing object on the worksheet.

Figure 24.9

Macros can be assigned to any drawing object on the worksheet.

I prefer this method because I can easily add a drawing object with macro code and use the .OnAction property to assign a macro to the object. There is one big drawback to this method. If you assign a macro that exists in another workbook, and the other workbook is saved and closed, Excel changes the .OnAction for the object to be hard-coded to a specific folder.

0 0

Post a comment