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.
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
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.
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...
Im using ctrl + : to insert a static system time into a worksheet, but I can only get it to insert hours/ minutes. Is there a way of including seconds? (it currently rounds down to the previous minute).
thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.