Deactivated worksheet right click menu - cannot reactivate!

[monkski]

I was trying to deactivate the right click menu on my worksheet tabs in excel 2003, which i did as per thread

http://www.tek-tips.com/viewthread.cfm?qid=855738

using the following line of code;

CommandBars("ply").Enabled = False

which worked fine - problem is it decativated the tabs in all worksheets in any file that i open in excel. So I deleted the code, but the setting remained - so i then set the value to true and my worksheet tabs are still decativated in any workbook i open.

please help!
Thanks

 

[combo]

Just enable this commandbar:

CommandBars("ply").Enabled = True

combo

 

[monkski]

Thats what i tried after deleting the code, but it has not reactivated the menu.

I tried rebooting etc. just in case, and it remains deactivated in any excel file I open.

 

[monkski]

I believe maybe I am not putting the code in the correct place - although I have tried within worksheet objects and modules

- could anyone advise where it should sit?
thanks

 

[combo]

In Visual Basic Editor display 'Immediate Window' (View > Immediate Window), copy the code, go to end of line and press enter. It can also be added to any procedure and executed. If it does not work, maybe the commandbar is disabled in one of auto macros, in a workbook or installed add-in.
However, the menu should be enabled for some time after executing this line of code.

combo

 

[monkski]

Thanks very much for your help - that worked.
I reran the macro (there is only one in this workbook) and it didnt turn the menus back off, so Im still not entirely sure why the problem arose.

thanks for your help.

 

[rmikesmith]

In the VB Editor, open the Immediate window then type the following in and press the Enter key:

CommandBars("ply").Enabled = True

This should restore normal functionality.

Regards,
Mike

 

[rmikesmith]

Sorry Combo, Monkski

I'm a bit slow.

Mike