ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combobox moves when worksheet is printed??? (https://www.excelbanter.com/excel-programming/349203-combobox-moves-when-worksheet-printed.html)

hurlbut777

Combobox moves when worksheet is printed???
 
I have a worksheet that contains several comboboxes. While viewing the
worksheet, if I press the print icon in the toolbar the comboboxes all move
across the spreadsheet to a new position. If I close the file and re-open
all is good, but if I save the file, close, and then re-open...not good. Any
idea what is causing the comboboxes to move, and more importantly, how to fix
it?

Dave Peterson

Combobox moves when worksheet is printed???
 
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.

hurlbut777 wrote:

I have a worksheet that contains several comboboxes. While viewing the
worksheet, if I press the print icon in the toolbar the comboboxes all move
across the spreadsheet to a new position. If I close the file and re-open
all is good, but if I save the file, close, and then re-open...not good. Any
idea what is causing the comboboxes to move, and more importantly, how to fix
it?


--

Dave Peterson


All times are GMT +1. The time now is 02:49 PM.

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