PC Review


Reply
Thread Tools Rate Thread

Disappearing Command Button

 
 
Marc S
Guest
Posts: n/a
 
      17th Mar 2008
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?
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      17th Mar 2008
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.



Marc S wrote:
>
> 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
 
Reply With Quote
 
Marc S
Guest
Posts: n/a
 
      17th Mar 2008
On Mar 17, 2:24*pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> 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.
>
> Marc S wrote:
>
> > 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




No dice.
 
Reply With Quote
 
Bob I
Guest
Posts: n/a
 
      17th Mar 2008
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.



Marc S wrote:

> On Mar 17, 2:24 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
>
>>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.
>>
>>Marc S wrote:
>>
>>
>>>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

>
>
>
>
> No dice.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
print command from command button in userform causes double chart Mike Jamesson Microsoft Excel Programming 5 11th Aug 2009 03:42 AM
Deselect Command Button by Selecting another Command Button gmcnaugh Microsoft Excel Programming 3 2nd Sep 2008 05:59 PM
Command Button Pictures Taken from Command Bar Button Icons acx@centrum.cz Microsoft Access Forms 0 2nd Dec 2007 12:23 PM
disappearing footnote command =?Utf-8?B?S2Vlc1c=?= Microsoft Word Document Management 2 10th May 2005 03:39 AM
News command disappearing. =?Utf-8?B?VmljdG9y?= Microsoft Outlook Discussion 1 27th Oct 2003 10:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:18 AM.