Enable Menu Items in Excel - Save ME

[vijay2482]

hi all,

i was trying to disable menu items in the menubar of excel.
i have disabled save,save as from file menu and cut,copy,paste from edit menu and the save icon in toolbar......
the disable was working fine...

now i was allthese items to be activated...
so i changed the code but im not able to do it.

what should i do to reactivate them again??
i have deleted those code from the module but even then ithe items are not activated.

please help...

without those items,i cannot continue my work
please save me...........

thanks in advance

 

[xld]

Quick way

Application.Commandbars("Worksheet Menu Bar").Reset

 

[vijay2482]

thanks a lot..
i dont know how to explain my gratitude to you..
if i did not get the solution,my entire work would have been spoiled....
thank you very much........


make me understand:
normally the menuitem should be active in excel.
i have deactivated in only one excel file, but why it has been deactivated in the entire excel environment???
should i have this code always in my excel macro for the menu items to be active always?

if i remove that particular code from the macro in my one excel file, the menu items are deactivated again.
what is the reason for it???
how to solve this issue???
i want to deactivate the menu item in only one particular file and not in the whole excel environment...
please give an apt solution...

thanks once again