Hello all,

I have a spreadsheet utilizing various command buttons (navigational)
throughout the entire sheet. I am experiencing an alignment problem with a
set of command buttons listed within the top row of the sheet, which is a
frozen pane. Whenever I switch to Print Preview then return to the working
sheet, all of those command buttons consolidate over into the first 2
columns, rather than displaying evenly distributed on the first row.

Any help or suggestions would be greatly appreciated

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


http://groups.google.co.uk/groups?lr...apeXSP AM.com


but there was a discussion on this:

DAVE PETERSON:

There's a link on this URL:
http://support.microsoft.com/default.aspx?kbid=838910

How to obtain the hotfix

This issue is fixed in the Excel 2002 post-Service Pack 3 hotfix Hotfix
Package
May 6, 2004. For additional information, click the following article number
to
view the article in the Microsoft Knowledge Base:
829348 Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004

That points to this KB article:
http://support.microsoft.com/kb/829348/
Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004

That describe how to contact MS to get the link. It's not just a simple
download.

Jim Rech says it is fixed in a security update so the hotfix isn't needed:

Jim Rech:
I think it is, Dave, because it was included in the 10/12/2004 Security
Update. MSKB 873366 describes how to get it. As I recall the fix isn't
mentioned in the doc, it is there; I read it somewhere and proved to my
satisfaction that it worked. I'd be interested to see if you can confirm
this.

see the discussion:
http://groups.google.co.uk/groups?lr...apeXSP AM.com

--
Regards,
Tom Ogilvy

"zabo21" wrote in message
...
Hello all,

I have a spreadsheet utilizing various command buttons (navigational)
throughout the entire sheet. I am experiencing an alignment problem with
a
set of command buttons listed within the top row of the sheet, which is a
frozen pane. Whenever I switch to Print Preview then return to the
working
sheet, all of those command buttons consolidate over into the first 2
columns, rather than displaying evenly distributed on the first row.

Any help or suggestions would be greatly appreciated

Thanks a bunch, I was able to fix it after reading your suggesitons.

"Tom Ogilvy" wrote:

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


http://groups.google.co.uk/groups?lr...apeXSP AM.com


but there was a discussion on this:

DAVE PETERSON:

There's a link on this URL:
http://support.microsoft.com/default.aspx?kbid=838910

How to obtain the hotfix

This issue is fixed in the Excel 2002 post-Service Pack 3 hotfix Hotfix
Package
May 6, 2004. For additional information, click the following article number
to
view the article in the Microsoft Knowledge Base:
829348 Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004

That points to this KB article:
http://support.microsoft.com/kb/829348/
Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004

That describe how to contact MS to get the link. It's not just a simple
download.

Jim Rech says it is fixed in a security update so the hotfix isn't needed:

Jim Rech:
I think it is, Dave, because it was included in the 10/12/2004 Security
Update. MSKB 873366 describes how to get it. As I recall the fix isn't
mentioned in the doc, it is there; I read it somewhere and proved to my
satisfaction that it worked. I'd be interested to see if you can confirm
this.

see the discussion:
http://groups.google.co.uk/groups?lr...apeXSP AM.com

--
Regards,
Tom Ogilvy

"zabo21" wrote in message
...
Hello all,

I have a spreadsheet utilizing various command buttons (navigational)
throughout the entire sheet. I am experiencing an alignment problem with
a
set of command buttons listed within the top row of the sheet, which is a
frozen pane. Whenever I switch to Print Preview then return to the
working
sheet, all of those command buttons consolidate over into the first 2
columns, rather than displaying evenly distributed on the first row.

Any help or suggestions would be greatly appreciated