Thanks OssieMac, I've added this in.

"OssieMac" wrote:

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.

"ChrisO" wrote:

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

Chris

"OssieMac" wrote:

On the machine that is not working try menu item Tools, Options, View tab and
under objects set to show all

"ChrisO" wrote:

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