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.)

tschee wrote:

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

--
tschee
------------------------------------------------------------------------
tschee's Profile: http://www.excelforum.com/member.php...o&userid=25897
View this thread: http://www.excelforum.com/showthread...hreadid=383117

--

Dave Peterson