I'd blame a developer!

Sometimes people want to take control of everything that excel can do. And
either they forget to put things back when they're done or something screws up
(excel/windows crashes) and the clean up code doesn't get run.

If you're the developer who may have done this, welcome to the club!



DeanH wrote:

Fantastic, Dave, You are the man!

This fix worked a treat.
Any idea why the toolbar fell over in the first place?
Or is it just a Microsoft thing! ;-)

Anyway, many thanks.
DeanH

"Dave Peterson" wrote:

Maybe it's time to reset that toolbar.

Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window

Then type this and hit enter:
application.commandbars("ply").reset
Then back to excel to test it.


DeanH wrote:

Excel 2000 SP3

I have noticed that all the options for the Sheet Tabs (mouse-right click)
are greyed out.
Is there a check box somewhere to turn them back on?

Many thanks in advance.
DeanH

--

Dave Peterson


--

Dave Peterson