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?

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?

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?