![]() |
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