Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Disappearing Command Button

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Marc S - 17 Mar 2008 18:14 GMT
I have an Excel sheet created in Excel 2003 and saved as Excel 5.0/
Excel 2002... blah blah blah.   The workbook has 4 sheets and the last
2 sheets contain command buttons. When a coworker opens the workbook
using Excel 2003 everything is fine. When another coworker opens the
book using Excel 2002 (and Windows 2K instead of XP) the button is not
there. The code is there but no button.

When the coworker using Office 2002 moves the mouse around where the
button should be, every once in a while the button will appear but
then randomly go away. I tried uisng the ScreenUpdating=true oprion
that I found on one thread but to no avail.

Any ideas?
Dave Peterson - 17 Mar 2008 19:24 GMT
Just a guess...

Clean up the windows temp folder on the troublesome pc.

Close excel
Windows start button|Run
type:
%temp%
and hit enter.
Clean up all the files that you can.

Then restart excel and test it out.

Excel stores lots of info about these controls in the temp folder.  If there's
too much junk there, it can confuse excel.

> I have an Excel sheet created in Excel 2003 and saved as Excel 5.0/
> Excel 2002... blah blah blah.   The workbook has 4 sheets and the last
[quoted text clipped - 9 lines]
>
> Any ideas?

Signature

Dave Peterson

Marc S - 17 Mar 2008 21:31 GMT
> Just a guess...
>
[quoted text clipped - 29 lines]
>
> Dave Peterson

No dice.
Bob I - 17 Mar 2008 21:58 GMT
Perhaps dial back a notch or two on the Video adapter hardware
acceleration setting. I don't remember if Win2K is the same, but R-click
the desktop, then Properties, Settings, Advanced, then Troubleshoot,
Hardware acceleration.

>>Just a guess...
>>
[quoted text clipped - 31 lines]
>
> No dice.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.