Command Buttons

  • Thread starter Thread starter jo2389hn
  • Start date Start date
J

jo2389hn

I have 3 command buttons (CB's) linked to macros on a spreadsheet. Two
carry out functions, move data, update etc etc. No problem with these.
The third is just a button to "Print Page" and when pressed will do
just that. The problem is that when pressed the other two CB's move
from their position to another part of the spreadsheet. I think the
problem is something to do with the selection of the print range, but
how do I prevent these buttons from moving i.e. "anchor" them in
position. Any help greatly appreciated. Regards John.
 
xl2002???

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

But Jim Rech recently posted this:
This article is now obsolete. Since the 10/12/2004 security patch
there is no need to get a hotfix (although this article does not directly
mention this fix, it's in there).

http://support.microsoft.com/default.aspx?scid=kb;en-us;832332

But Myrna Larson (and others) posted that it didn't work for her in all her
workbooks.
 
Back
Top