hello,
i am using excel 2000. i have designed a form in a worksheet by placing
objects (checkbox, radiobuttons, text boxes, labels) in excel. the problem:
when i save and preview or print the document, the printout is same as the
form designed, after printing/previewing the document, when i return to
worksheet, all the objects are aligned towards left (into a single column)-
overlappping each other. if i donot save this, close and reopen the workbook,
the objects are back in ther place, as designed.

can somebody help in resolving this alignment problem.

Why don't you use a standard userform, this problem will then disappear.


---
HTH

Bob Phillips

"navinpv" wrote in message
...
hello,
i am using excel 2000. i have designed a form in a worksheet by placing
objects (checkbox, radiobuttons, text boxes, labels) in excel. the
problem:
when i save and preview or print the document, the printout is same as the
form designed, after printing/previewing the document, when i return to
worksheet, all the objects are aligned towards left (into a single
column)-
overlappping each other. if i donot save this, close and reopen the
workbook,
the objects are back in ther place, as designed.

can somebody help in resolving this alignment problem.

You sure you have Excel 2000?

Not sure if this applies or not..................

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 others have posted that it didn't work for them in all their workbooks.


Gord Dibben Excel MVP


On Mon, 7 Dec 2009 20:29:01 -0800, navinpv
wrote:

hello,
i am using excel 2000. i have designed a form in a worksheet by placing
objects (checkbox, radiobuttons, text boxes, labels) in excel. the problem:
when i save and preview or print the document, the printout is same as the
form designed, after printing/previewing the document, when i return to
worksheet, all the objects are aligned towards left (into a single column)-
overlappping each other. if i donot save this, close and reopen the workbook,
the objects are back in ther place, as designed.

can somebody help in resolving this alignment problem.