ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Manually assigning Macros to Buttons w/o File Dependence (https://www.excelbanter.com/excel-programming/311042-manually-assigning-macros-buttons-w-o-file-dependence.html)

John Loo

Manually assigning Macros to Buttons w/o File Dependence
 
OK, another dumb one...I would like to assign a macro to a toolbar button in
a way which points to a macro of that name in the current workbook, without
having to write code to do this.

Right now, when I assign the macro manually, then save the spreadsheet under
a different name, Excel adds the originating spreadsheet's name to the macro
assignment in the toolbar button.

I'm looking for something like: Thisworkbook!macroname or Me.macroname.


All times are GMT +1. The time now is 05:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com