LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Key Assignment Log Norma Excel Discussion (Misc queries) 0 May 12th 05 04:10 PM
assignment problem L. Chung Excel Worksheet Functions 1 April 17th 05 06:06 AM
excel assignment Davko Excel Discussion (Misc queries) 1 April 15th 05 08:32 AM
Relative Macro Assignment esskaykay Excel Programming 3 April 25th 04 10:55 PM
Macro assignment to button gets reassigned John Gittins Excel Programming 1 August 5th 03 10:18 PM


All times are GMT +1. The time now is 09:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"