Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Command Buttons

Status
Not open for further replies.

kosdav

Programmer
Mar 6, 2009
3
CA
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.
 
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
VBA, C#, Delphi
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top