View Single Post
  #1   Report Post  
Les Gordon
 
Posts: n/a
Default Printing objects on a worksheet

I have a simple macro that sets the pagesetup properties (more or less just
the printarea) and then prints the worksheet.

Every time I do this two of the objects move - a command button and a
spinner; it doesn't matter if the properties are set to print or not, they
move over to the left.

Is there some property I should be setting to anchor to a cell or something?

Regards
--
Les Gordon