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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 01:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com