Buttons displaying for a half second, then disappearing

Joined
May 8, 2003
Messages
29
Hello all,

I've posted this question in tandem with another problem I had in the following thread http://www.mrexcel.com/board2/viewtopic.php?t=63240&highlight= but never received an answer to this portion of the question. Therefore, I am starting a thread specifically for this problem. Hope you don't mind.

Win98, Excel 97/8

I have a spreadsheet with a number of buttons (6) at the top of the spreadsheet. When the spreadsheet is opened up the 6 buttons display for a split second and then promptly disappear, leaving 1 grey box the size and shape of the first button. This grey box cannot be clicked and or moved. It just "exists". :oops:

The only way I can get the macros (tied to the buttons) to run is to go in to Visual Basic and run them from there. Counter-productive to say the least.

Nothing I can see explains this behaviour. Can anyone come up with a "fix" for this?

Thanks in advance,
Loki
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Do you know what type of control it is ?
Sometimes if you have an ActiveX control created by another SS Application run on another, the Control will not show properly. AFAIK this is because it is not registered on the current SS or it has lost the registered link.
If this is correct then you need to register the control.
 
Upvote 0
Excuse my ignorance .. but I am not sure what you mean by "type of control".

All I did was create the macros in Visual Basic and then I created the buttons and tied that buttons to their respectice macros. I didn't use Active X.

So how would I go about registering the control?

Thanks,
Loki
 
Upvote 0

Forum statistics

Threads
1,215,465
Messages
6,124,982
Members
449,201
Latest member
Lunzwe73

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top