Excel Command Buttons

[kosdav]

I have a set of worksheets that I have buttons on. I have the buttons set to not print, and not move or resize wiht cells. The problem is when I preview the worksheet the buttons move to whereever they like when I close the print preview.

Any ideas as to how to stop this button movement?
I am using Excel 2002.

 

[paulmatt]

Not sure - I don't use buttons in the spreadsheet itself.

You could use buttons on the toolbar instead to side step the issue. (r-click toolbar > customise > macros, drag new btn to toolbar, r-click btn > assign macr).

Paul Rigby

http://www.awgarstone.com

VBA, C#, Delphi

 

[kosdav]

Thanks, but it is not condusive to my application to use menus.
It seems that the buttons only move after the user previews the sheet. I have wrote code to reposition the buttons after the user closes the preview, but that is only a hack. I would like to know how to stop it from happening in the first place.