Menu Restoration
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
|