ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stop my "combo box" from changing locations after print previewin. (https://www.excelbanter.com/excel-discussion-misc-queries/72383-stop-my-combo-box-changing-locations-after-print-previewin.html)

murphytsa

Stop my "combo box" from changing locations after print previewin.
 
I have created a combo box in Excel. I place it in the location I would like
it to stay, however, when I do a print preview of the sheet, it changes the
location of the box. Any solutions?

Dave Peterson

Stop my "combo box" from changing locations after print previewin.
 
xl2002???

http://support.microsoft.com/default...b;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

But Jim Rech recently posted this:
This article is now obsolete. Since the 10/12/2004 security patch
there is no need to get a hotfix (although this article does not directly
mention this fix, it's in there).

http://support.microsoft.com/default...b;en-us;832332

But Myrna Larson (and others) posted that it didn't work for her in all her
workbooks.

murphytsa wrote:

I have created a combo box in Excel. I place it in the location I would like
it to stay, however, when I do a print preview of the sheet, it changes the
location of the box. Any solutions?


--

Dave Peterson

Doug Kanter

Stop my "combo box" from changing locations after print previewin.
 

"murphytsa" wrote in message
...
I have created a combo box in Excel. I place it in the location I would
like
it to stay, however, when I do a print preview of the sheet, it changes
the
location of the box. Any solutions?


Is it possible the sheet has been set to automatically fit into the printed
page? File, Page Setup, look under "Scaling" on the Page tab. I see that
it's a known problem in Excel 2002, but I wonder if there could be more than
one thing going on here.




All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com