Control buttons missing

C

ChrisO

Hello,

I am sure this is something obvious but its driving me mad....

I have a workbook with control buttons on several sheets to run various
macros. It all looks fine to me and also for another user, but for one
particular guy when he opens the workbook the buttons on the sheet first
displayed appear momentarily and then disappear, and then there are no
buttons shown on any sheets. He has his macro security level set to medium,
like the rest of us, and clicks the enable macros button when he opens the
workbook. What is even more odd is that once or twice he has opened the
spreadsheet and the buttons are there. We are on Excel 2003.

If anyone can enlighten me on what's going on it would be much appreciated.

Thanks.

Chris
 
O

OssieMac

Hello,

I am sure this is something obvious but its driving me mad....

I have a workbook with control buttons on several sheets to run various
macros. It all looks fine to me and also for another user, but for one
particular guy when he opens the workbook the buttons on the sheet first
displayed appear momentarily and then disappear, and then there are no
buttons shown on any sheets. He has his macro security level set to medium,
like the rest of us, and clicks the enable macros button when he opens the
workbook. What is even more odd is that once or twice he has opened the
spreadsheet and the buttons are there. We are on Excel 2003.

If anyone can enlighten me on what's going on it would be much appreciated.

Thanks.

Chris
 
C

ChrisO

Thanks. Unfortuately he isn't seeing the problem today but next time he does
I'll check this. Thanks for your help.

Chris
 
O

OssieMac

As it is intermittent, it is possible that the option is altered by another
macro being run by the user because if set in a maco it remains set until
changed by the user or in a macro. If it persists you could try using a macro
procedure named "Sub Auto_Open()" for which I cannot find documented in help
but a sub named as this will run each time the workbook is opened. Simply
record a macro when setting the option to get the syntax and insert it in the
Auto_Open sub. Additional tip "Sub Auto_Close()" runs on shutdown of the
workbook.
 
C

ChrisO

Thanks OssieMac, I've added this in.

OssieMac said:
As it is intermittent, it is possible that the option is altered by another
macro being run by the user because if set in a maco it remains set until
changed by the user or in a macro. If it persists you could try using a macro
procedure named "Sub Auto_Open()" for which I cannot find documented in help
but a sub named as this will run each time the workbook is opened. Simply
record a macro when setting the option to get the syntax and insert it in the
Auto_Open sub. Additional tip "Sub Auto_Close()" runs on shutdown of the
workbook.
 
C

ChrisO

We saw the problem again this morning, and checked that the excel option
below was set correctly (it was). Our theory now is that it occurs when the
user's IBM ThinkPad is connected to a projector, which needs display settings
to be changed. I've no idea why this seems to result in the excel buttons
disappearing or why it only seems to affect this one user (a couple of other
ThinkPad users are OK).

Any theories on what is going on, and how to overcome it would be very
welcome!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top