Custom Menu

[nateshk]

Hi,

I have created a custom menu and menu item with in it to call a macro.

The Custom menu appears on the top of the sheet along with File,Edit... menu options.

But after i close the sheet and later open it , the custome menu is no longer there.

Can anyone help me on it ?

Thanx a ton

Natesh

 

[RobBroekhuis]

Excel's normal behavior is to retain all changes to its menu bars indefinitely. So if you make a change, leave Excel, and come back, the change should still be there (not necessarily what you want, of course). If you can be more specific about how you created the custom menu (manually? by code?), and what you do to disable it after you're done needing it, I'm sure we can help.
Rob

 

[nateshk]

hi RobBroekhuis ,

Thanx Rob, but i found out the problem. The menu was custome generated thru code.

Thanx for the help.

Regards.

Natesh