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!
"ChrisO" wrote:
> 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
|
Similar Threads
