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

ketan wrote:

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!

--
Amedee Van Gasse using XanaNews 1.16.3.1
If it has an "X" in the name, it must be Linux?
Please don't thank me in advance. Thank me afterwards if it works or
hit me in the face if it doesn't. ;-)

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.


ketan wrote:

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

--

Dave Peterson

Dave Peterson wrote:

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.

--
Amedee Van Gasse using XanaNews 1.16.3.1
If it has an "X" in the name, it must be Linux?

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,


"Amedee Van Gasse" wrote in message ...
Dave Peterson wrote:

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.

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 wrote:

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,

"Amedee Van Gasse" wrote in message ...
Dave Peterson wrote:

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.

--

Dave Peterson

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)

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)

--

Dave Peterson

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)