When I open excel there is no menu appeared. All the menus are disappeared
and i am unable to clik right mouse button also.

I think i might have clicked to something hide menu. How can show them again?

hi,
I'm not sure if this will do it for you but it's worth a try.
press the keyboard keys Alt +F11. this will bring up the VB editor.
In the VB editor click Insertmodule.
Paste this code in the code window.

Sub macMenu()

Application.CommandBars("Worksheet Menu Bar").Visible = True
Application.CommandBars("Standard").Visible = True

End Sub

to run the macro click runrunsub/userform or just hit the F5 key.

this should put the menu and the standard toolbar in excel. you should then
be able to right click the tool bar and customize

Good luck.
hope this helped
regards
FSt1

"Saravanan" wrote:

When I open excel there is no menu appeared. All the menus are disappeared
and i am unable to clik right mouse button also.

I think i might have clicked to something hide menu. How can show them again?

That should be

Application.CommandBars("Worksheet Menu Bar").Enabled = True


--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"FSt1" wrote in message
...
hi,
I'm not sure if this will do it for you but it's worth a try.
press the keyboard keys Alt +F11. this will bring up the VB editor.
In the VB editor click Insertmodule.
Paste this code in the code window.

Sub macMenu()

Application.CommandBars("Worksheet Menu Bar").Visible = True
Application.CommandBars("Standard").Visible = True

End Sub

to run the macro click runrunsub/userform or just hit the F5 key.

this should put the menu and the standard toolbar in excel. you should
then
be able to right click the tool bar and customize

Good luck.
hope this helped
regards
FSt1

"Saravanan" wrote:

When I open excel there is no menu appeared. All the menus are
disappeared
and i am unable to clik right mouse button also.

I think i might have clicked to something hide menu. How can show them
again?

Thanks Guys. I used the both enabled and visible, now it is showing toolbar
only not the menu. Also I am unable click the right mouse button. Expecting
you help. Thanks.

Regards,
Saravanan

"Bob Phillips" wrote:

That should be

Application.CommandBars("Worksheet Menu Bar").Enabled = True


--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"FSt1" wrote in message
...
hi,
I'm not sure if this will do it for you but it's worth a try.
press the keyboard keys Alt +F11. this will bring up the VB editor.
In the VB editor click Insertmodule.
Paste this code in the code window.

Sub macMenu()

Application.CommandBars("Worksheet Menu Bar").Visible = True
Application.CommandBars("Standard").Visible = True

End Sub

to run the macro click runrunsub/userform or just hit the F5 key.

this should put the menu and the standard toolbar in excel. you should
then
be able to right click the tool bar and customize

Good luck.
hope this helped
regards
FSt1

"Saravanan" wrote:

When I open excel there is no menu appeared. All the menus are
disappeared
and i am unable to clik right mouse button also.

I think i might have clicked to something hide menu. How can show them
again?