Thats right. Also I would have never imagine such name (Adaptive menu)
for such an action (Short or full menu). But then thats where the NG
comes in picture.

Thanks and Have a nice day,
Bye,
Ketan


Dave Peterson wrote in message ...
Glad it worked for you, but who'da guessed that the macro wouldn't record?
(well, not me!)

ketan wrote:

Dave,
Thanks. It worked.
I put this in personal workbook.
Thanks and regards,
Ketan

Dave Peterson wrote in message ...
Darn, I didn't actually test this!

But this seemed to work ok for me:

Option Explicit
Sub auto_open()
Application.CommandBars.AdaptiveMenus = False
ThisWorkbook.Close savechanges:=False
End Sub

(in a general module)