| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where have my macro links gone?
I've created a spreadsheet with lots of buttons, each being assigned a
different macro. However, every time I open the spreadsheet, these macro links disappear. So I have to right click on every single button in the spreadsheet and assign the macros again from scratch. Why is this happening? And how do I make sure that the system remembers which macros I've assigned to the various buttons, every time the spreadsheet is opened? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where have my macro links gone?
Hmm, strange.
Where do you put these macro's? In your file or in Personal.xls? -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Savman" wrote: I've created a spreadsheet with lots of buttons, each being assigned a different macro. However, every time I open the spreadsheet, these macro links disappear. So I have to right click on every single button in the spreadsheet and assign the macros again from scratch. Why is this happening? And how do I make sure that the system remembers which macros I've assigned to the various buttons, every time the spreadsheet is opened? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where have my macro links gone?
Hi Wigi,
The macros are in the modules section of the project (so they are contained in the same spreadsheet). "Wigi" wrote: Hmm, strange. Where do you put these macro's? In your file or in Personal.xls? -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Savman" wrote: I've created a spreadsheet with lots of buttons, each being assigned a different macro. However, every time I open the spreadsheet, these macro links disappear. So I have to right click on every single button in the spreadsheet and assign the macros again from scratch. Why is this happening? And how do I make sure that the system remembers which macros I've assigned to the various buttons, every time the spreadsheet is opened? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Break Links Macro help... | Excel Programming | |||
| Report with macro losing links to a particular worksheet after running macro | Excel Programming | |||
| Using Macro to update Links | Excel Programming | |||
| A macro to update links | Excel Programming | |||
| change links by a macro | Excel Programming | |||
Linear Mode
