Control buttons missing

[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

 

[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

 

[ChrisO]

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

Chris

 

[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 Autpen()" 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
Autpen sub. Additional tip "Sub Auto_Close()" runs on shutdown of the
workbook.

 

[ChrisO]

Thanks OssieMac, I've added this in.

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 Autpen()" 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
Autpen sub. Additional tip "Sub Auto_Close()" runs on shutdown of the
workbook.

 

[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!

 

[Salah Gulay]

Check out this thread
http://www.excelforum.com/showthread.php?t=580053

*** Sent via Developersdex http://www.developersdex.com ***