ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Check Box Moves (https://www.excelbanter.com/excel-programming/371257-check-box-moves.html)

Nicole99

Check Box Moves
 
Running Excel 2002 on XP platform. Having difficulties with a check box. The
check box is setup and properly functioning, however, when the form is sent
to printer, the checkbox jumps over to the left of the spreadsheet. Tried
Properties in Design Mode but nothing there seems to affect behaviour of this
checkbox in this regard.

Could this be an issue with XP running Excel 2002 since I don't recall
having this problem earlier? Any suggestions or tips? Thanks.

Ron de Bruin

Check Box Moves
 
Hi

Could this be an issue with XP running Excel 2002

Correct
See http://support.microsoft.com/kb/838910/en-us


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Nicole99" wrote in message ...
Running Excel 2002 on XP platform. Having difficulties with a check box. The
check box is setup and properly functioning, however, when the form is sent
to printer, the checkbox jumps over to the left of the spreadsheet. Tried
Properties in Design Mode but nothing there seems to affect behaviour of this
checkbox in this regard.

Could this be an issue with XP running Excel 2002 since I don't recall
having this problem earlier? Any suggestions or tips? Thanks.




Jim Thomlinson

Check Box Moves
 
That is a known issue (there is an MSDN article describing the problem).
Instead of going to Properties go to Format Controls - Properties -Select
"Move and Size with Cells" option (Top Option). That should fix it...
--
HTH...

Jim Thomlinson


"Nicole99" wrote:

Running Excel 2002 on XP platform. Having difficulties with a check box. The
check box is setup and properly functioning, however, when the form is sent
to printer, the checkbox jumps over to the left of the spreadsheet. Tried
Properties in Design Mode but nothing there seems to affect behaviour of this
checkbox in this regard.

Could this be an issue with XP running Excel 2002 since I don't recall
having this problem earlier? Any suggestions or tips? Thanks.



All times are GMT +1. The time now is 10:48 AM.

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