Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
distributing a spreadsheet with macro buttons
How do you distribute an Excel 2003 spreadsheet application with buttons
linked to macros? Do you actually have to relink all buttons to the macros for every new location? I can't believe that - I must be overlooking something. My spreadsheet has buttons which are linked to macros. When the spreadsheet is moved to a different location (on the same computer or a new computer), the following error occurs when a button is clicked: "A document with the name fubar.xls is already open. You cannot open two documents with the same name etc." I moved all macros into the Sheet1 Excel Object. That didn't help. I have tried using buttons from the control toolbox (which I read should correct this but doesn't), and from the forms toolbox, and the "custom menu item" from the macros list. Nothing works. When I put the spreadsheet on another machine, sometimes the buttons are there but I have to link them to the macros. Sometimes the buttons aren't there at all. I don't understand this and can't find anything to clarify it. Where are the toolbars stored? Why can't the buttons just look in the current workbook for the macros? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
distributing spreadsheet revisions. | Excel Discussion (Misc queries) | |||
Replacing macro buttons with a new set of buttons | Excel Programming | |||
Spreadsheet print including macro buttons? | Excel Discussion (Misc queries) | |||
How do i print out my spreadsheet with macro buttons? | Excel Discussion (Misc queries) | |||
distributing a macro | Excel Programming |