How to keep showing full menu?

[ketan]

Whenever I open excel, it shows only recently used menus first.
I tried to chenge the option in right click >> customise and
unchecking the box in front of "Menus show recently used commands
first and " show full menu after a short delay" but it works only for
the current session. Once I close and reopen excel, it again displays
annoying short menus.

Is there a way to keep showing full menus permanantly whenever I open
the excel?

Thanks,
Ketan

 

[Amedee Van Gasse]

Whenever I open excel, it shows only recently used menus first.
I tried to chenge the option in right click >> customise and
unchecking the box in front of "Menus show recently used commands
first and " show full menu after a short delay" but it works only for
the current session. Once I close and reopen excel, it again displays
annoying short menus.

Is there a way to keep showing full menus permanantly whenever I open
the excel?

Thanks,
Ketan

Are you working in some kind of Terminal or Citrix environment???
Or perhaps you don't have sufficient rights???
Or some app that prevents changes to the registry? I had to uninstall
AdWatch for similar reasons.
Anyway what you describe (customise, unchecking that box) *is* the
right way to do it!

 

[Dave Peterson]

If you can't get sufficient rights to update the registry, maybe you could just
record a macro while you set this.

Name your macro auto_open.
Then save that workbook in your XLStart folder.
Add this line right before the End Sub:
thisworkbook.close savechanges:=false

Then when you open excel, this workbook will open, the setting will be changed,
and the workbook will close.

Then try to find out what else you can't change and see if your IT people can
help.

 

[Amedee Van Gasse]

If you can't get sufficient rights to update the registry, maybe you
could just record a macro while you set this.

Name your macro auto_open.
Then save that workbook in your XLStart folder.
Add this line right before the End Sub:
thisworkbook.close savechanges:=false

Then when you open excel, this workbook will open, the setting will
be changed, and the workbook will close.

Then try to find out what else you can't change and see if your IT
people can help.

Dave,
smart workaround!
I'll remember that, I often envounter clients with all their rights
stripped away.

 

[ketan]

Sorry, Iwas on leave so could not reply.
I have full Administrators rights.
We have win2000 with office 2000. I can do all the changes required to
the registry. In fact I have made many changes for some other purpose.

Dave,
Recording a macro during I set it does not record anything. It shows
just the sub Macro1() and End sub line.

Is there any other way around?

Regards,

 

[Dave Peterson]

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)

 

[ketan]

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

 

[Dave Peterson]

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

 

[ketan]

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