Command Buttons Disappear

[Guest]

I have command buttons on my Excel 2003 worksheet to activate recorded macros
and VBA code. I attached this file to an email and sent it to the user. He
has Excel 2002. It worked for a short time, then the command buttons
disappeared. He sent the same file with his data entered in it to another
user who had Excel 2003. The command buttons reappeared for that user. I
copied the worksheet to a disk. With his laptop I opened the Excel file on
the disk. No command buttons. What is going on?

Thanks in advance
Joe

 

[Jim Rech]

What is going on?

No idea. But do yourself a favor next time and use Forms toolbar buttons
rather than Control Toolbox command buttons. They're older and do not have
the same level of property control but they're also a lot more reliable.

 

[Gord Dibben]

Don't know if this is the case or not but might be worth a look........

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

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.aspx?scid=kb;en-us;832332

But others have posted that it didn't work for them in all their workbooks.


Gord Dibben Excel MVP

 

[Guest]

Thanks guys. Perhaps the easiest solution would be to install Excel 2003 or
newer.