View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
duuxxyy duuxxyy is offline
external usenet poster
 
Posts: 1
Default Macro assignment disappears

Good morning community,

I have a problem with my macro buttons...

The situation is: I have 5 different chart-sheets. On each of these sheets,
there is a macro button. Each macro button has a different macro assigned to
it. So, the button on sheet "M1" must run the macro "RefreshM1", etc. for
sheet M1 to M5.

The problem is that, sometimes (couldn't find the reason yet, let alone the
solution) when I open the file and want to run the macro, the button lost the
assigned macro... How is this possible? So I have to run through the 5
chart-sheets again and reassign each macro to its button.

What the macro does is call a small sub-end sub "RefreshM1( )", which then
calls another sub-end sub (common to all sheets this time).

Can it be because I made a copy/paste of the button of M1 to all other
sheets, then changed name and assigned macro?



Thanks in advance,
duxxyy.