Worksheet button sometimes disappears after macro runs??

[Baritone]

Has anyone had the experience of buttons disappearing from a worksheet
after the attached macro has run?

This only occurs once in a while, and I have not yet found a pattern.
I love a mystery, but this is very irritating. I would assume that if
it were a coding issue, it would occur every time, not every once in a
while.

I googled and found one fellow who had the same after printing, but no
solution was offered. Not a peep about it on MS Office for Mac
support.

I am running XL2004 for Mac, but the same error has occurred for a
colleague running XL2002 on XP, on the same sheet.

Any idea on how to stop this will be greatly appreciated!

Bari

 

[CyberTaz]

Hi Bari-

I haven't faced the issue but here are a few thoughts:

First, I assume the button you refer to is one drawn on the sheet to
run a macro or procedure as opposed to a button on a Toolbar.

When this does happen, what must you do to get the buttons to
re-appear? Could it just be a matter of refreshing the screen?

Does this happen regardless of how you run the macro, or only when you
click the button?

Does the macro sometimes involve cell that are covered by the button?

Have you checked Format>Control>Properties to see if it may be a
Move/Size issue?

Are there multiple buttons disappearing randomly, same button
consistantly, a specific macro as opposed to any macro?

If you post back with some additional info, I'm sure there will be some
useful responses.

As a temporary work-around, you might try adding a button to an
existing or new toolbar and assign the macro to it. That should give
back some functionallity until you get a more permanent resolution.

Hope this is useful. |:>)

 

[Baritone]

Hi Bari-

I haven't faced the issue but here are a few thoughts:

First, I assume the button you refer to is one drawn on the sheet to
run a macro or procedure as opposed to a button on a Toolbar.

Yes, the main offender is one of several buttons on the worksheet
that run vba scripts in Module1.

When this does happen, what must you do to get the buttons to
re-appear? Could it just be a matter of refreshing the screen?

After the first occurrence I learned to keep a dupe of the sheet. I
simply replace the sheet from a copy. The buttons run down the sheet
on the left side. Only one button is missing at a time, so it is not a
refresh issue.

Does this happen regardless of how you run the macro, or only when you
click the button?

I only run the script from the button unless I am coding, so the
problem only occurs when the button is pressed. But not every time.
Sometimes dozens of uses go by before it happens.

Does the macro sometimes involve cell that are covered by the button?

No. The macro copies data from one sheet to another, then exports a
sheet to a new workbook.

Have you checked Format>Control>Properties to see if it may be a
Move/Size issue?

No. Is there a way to check this once the button is gone? I can
select visible buttons and check via the contextual menu, or the format
menu.

Are there multiple buttons disappearing randomly, same button
consistantly, a specific macro as opposed to any macro?

Yes. I have had other buttons disappear, including on Userforms,
but the one mentioned above one disappears the most often. Only one
button at a time disappears, and only after its assigned macro has run.

If you post back with some additional info, I'm sure there will be some
useful responses.

Thank you for your response. In addition, here is my machine info:

Machine Model: iMac
CPU Type: PowerPC G4 (3.3)
Number Of CPUs: 1
CPU Speed: 1 GHz
L2 Cache (per CPU): 256 KB
Memory: 768 MB
Bus Speed: 133 MHz
Boot ROM Version: 4.5.8f1

Excel 2004 for Mac
Version 11.1

As a temporary work-around, you might try adding a button to an
existing or new toolbar and assign the macro to it. That should give
back some functionallity until you get a more permanent resolution.

Thanks. I also wonder if it could be a memory-related problem. I
also will try to clean my code as has been recommended on one of the
sites (copy the code and Userforms to a clean sheet).

 

[CyberTaz]

Hi Baritone-

Sorry for delay, but I was trying to simulate the problem in Excel '04.
Haven't been able to.

With 768 MB you should have ample RAM unless you are running several
files/apps at the same time or your file is very big.

Unfortunately, intermittent problems like this are the toughest to nail
down. I can appreciate your frustration, but I'm afraid I don't have
much to offer. The only suggestion would be to run the macros from the
Tools>Macro>Macros dialog box or create toolbar buttons instead of
using the button drawn on the sheet. If I come up with anything else
I'll let you know.

Good Luck |:>)