Lost Toolbar / Right click disabled

[Guest]

Hi,
two questions to ask??
1) I forgot to attach a personal toolbar back to my worksheet before closing
it , and now its has 'gone' - no sign of it in the cusomise toolbars section
- any ideas how to get this back??

2) My mouse seems to have lost the right click function within my excel
worksheet - any ideas how to get this back??

Thanks all

Anthony

 

[Dave Peterson]

#1. I think your life will be much smoother if you actually create the toolbar
when you open the workbook. (Then delete it when you close that workbook.)

I use a variation of John Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm
to add items to the worksheet menubar.

If I want to add a toolbar of my own, here's how I do it:
http://groups.google.co.uk/[email protected]

#2. Try this:

hit alt-f11 (to get to the VBE)
hit ctrl-g (to see the immediate window)

type this and hit enter:
application.commandbars("Cell").enabled = true
then back to excel to test.

If that didn't work, try this in the VBE immediate window:
application.commandbars("Cell").reset

 

[Guest]

Cheers Dave - I'll give that a go and thanks for helping

 

[tschee]

Hi Anthony & Dave,

Glad to read this thread. I've been facing this "right click missing"
problem lately, & now saved by Dave's method. Many thanks!

However I still cannot right-click on my roll & column tabs. How can
I restore this?

Regards,
Richard

 

[Dave Peterson]

You could try:

Application.CommandBars("column").Enabled = True
Application.CommandBars("column").Reset
and
Application.CommandBars("row").Enabled = True
Application.CommandBars("row").Reset

(all from the immediate window inside the VBE.)

But you could reset all your toolbars by:

Close excel
windows|start button|search
search for *.xlb
in hidden folders and files.

Rename all the *.xlb to *.xlbOLD.

Test it out.

If it worked, delete the *.xlbOLD files.

This means that any changes you've made to builtin toolbars is gone--but you can
recreate them at your leisure.

(When you've finished recreating those changes, find that *.xlb file and back it
up to a nice spot. If anything bad happens again, you just delete the bad *.xlb
and replace it with the backup.)