Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
My menu calls an old macro
I have created my own menu and connected a macro to my own ikon. I have then
renamed the spreadsheet. When opened on another PC my ikon does not work. It calls the right macro but wants to open the spreadsheet with the old name. How do I fix this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
My menu calls an old macro
Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the workbook is closed. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) Claus Højlund wrote: I have created my own menu and connected a macro to my own ikon. I have then renamed the spreadsheet. When opened on another PC my ikon does not work. It calls the right macro but wants to open the spreadsheet with the old name. How do I fix this? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
My menu calls an old macro
Dear Dave
My life has become much simpler. I used your version to create and delete a menubar. Very nice code. Thanks a lot for your help. Best regards Claus Højlund "Dave Peterson" wrote: Your life will become much simpler if you include code to create the toolbar when the workbook is opened and include code to destroy the toolbar when the workbook is closed. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) Claus Højlund wrote: I have created my own menu and connected a macro to my own ikon. I have then renamed the spreadsheet. When opened on another PC my ikon does not work. It calls the right macro but wants to open the spreadsheet with the old name. How do I fix this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem in updating all worksheets of a workbook using a macro that calls another macro | Excel Programming | |||
API calls, an Event handler, custom menu bar and modal | Excel Programming | |||
one macro calls the other | Excel Programming | |||
Macro Calls | Excel Programming | |||
"This macro calls that macro, which calls .."-how many? | Excel Programming |