| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
Hi Less
http://support.microsoft.com/d*efaul...;EN-US;8389*10 Controls move to the left of the worksheet in Microsoft Excel 2002 -- Regards Ron de Bruin http://www.rondebruin.nl "Les Gordon" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
THe link failed to produce a page but given your description I'll try a more
detailed search. I gather this is a "known bug". Thanks for the lead -- Les Gordon "Ron de Bruin" wrote: Hi Less http://support.microsoft.com/dÂ*efau...EN-US;8389Â*10 Controls move to the left of the worksheet in Microsoft Excel 2002 -- Regards Ron de Bruin http://www.rondebruin.nl "Les Gordon" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
Hi Less
Google is messing up the link This one is working http://support.microsoft.com/default...b;EN-US;838910 -- Regards Ron de Bruin http://www.rondebruin.nl "Les Gordon" wrote in message ... THe link failed to produce a page but given your description I'll try a more detailed search. I gather this is a "known bug". Thanks for the lead -- Les Gordon "Ron de Bruin" wrote: Hi Less http://support.microsoft.com/d*efaul...;EN-US;8389*10 Controls move to the left of the worksheet in Microsoft Excel 2002 -- Regards Ron de Bruin http://www.rondebruin.nl "Les Gordon" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Can I select a worksheet based upon a cell criteria?(for printing) | Excel Worksheet Functions | |||
| Why does an excel worksheet default to 24 copies when printing | Excel Worksheet Functions | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Linear Mode
