Hi

I have removed inbuilt Excel menus and replaced them with mine. Now if I
need to get back Excel to the default look I have restore the menus one by
one. Although it is a one minute task I like to know if it can be done with a
push of a button that is with with help of codes. If yes could someone let me
the know codes for reversing to default and for getting back to cutomised
position?

I will get back in touch on Monday.

Thanks and Regards

Varne

hi
yes it can be done with code. Any thing you do with the mouse or keyboard
can be done with code. not to mention a lot of other stuff.
repeat all of your actions of replacing your menus while on macro record.
excel will write the code for you. The record a second macro restoring
defaults. you can attach each macro to a custom toolbar button and reduce the
whole process to a button click.

Regards
FSt1

"Varne" wrote:

Hi

I have removed inbuilt Excel menus and replaced them with mine. Now if I
need to get back Excel to the default look I have restore the menus one by
one. Although it is a one minute task I like to know if it can be done with a
push of a button that is with with help of codes. If yes could someone let me
the know codes for reversing to default and for getting back to cutomised
position?

I will get back in touch on Monday.

Thanks and Regards

Varne

Hi

Thanks.

Your answer is correct.

I tried what you said on my computer but there were no codes. It was similar
to when you try to get the codes for copying something from Excel and
pasting onto Word. On this computer the first one works but not the later
one. Going by what you say I should have the codes for the later one also but
I am not getting it. If you do not mind please answer.

Thanks again.

M Varne



"FSt1" wrote:

hi
yes it can be done with code. Any thing you do with the mouse or keyboard
can be done with code. not to mention a lot of other stuff.
repeat all of your actions of replacing your menus while on macro record.
excel will write the code for you. The record a second macro restoring
defaults. you can attach each macro to a custom toolbar button and reduce the
whole process to a button click.

Regards
FSt1

"Varne" wrote:

Hi

I have removed inbuilt Excel menus and replaced them with mine. Now if I
need to get back Excel to the default look I have restore the menus one by
one. Although it is a one minute task I like to know if it can be done with a
push of a button that is with with help of codes. If yes could someone let me
the know codes for reversing to default and for getting back to cutomised
position?

I will get back in touch on Monday.

Thanks and Regards

Varne

I use a one-liner for each menu

Application.CommandBars(1).Controls("&HELP").Reset

Replace the &HELP with the correct menu name(s) that you wish to restore.
Thats the same as a Customize-Reset done manually.

Tim


"Varne" wrote:

Hi

I have removed inbuilt Excel menus and replaced them with mine. Now if I
need to get back Excel to the default look I have restore the menus one by
one. Although it is a one minute task I like to know if it can be done with a
push of a button that is with with help of codes. If yes could someone let me
the know codes for reversing to default and for getting back to cutomised
position?

I will get back in touch on Monday.

Thanks and Regards

Varne