Hi,
1. How to find out what are usual user's toolbars / menus / menus
rearrangements without actually opening new blank sheet?
2. How can I record customisations to the menu bar, so I can recreate them?
3. What event (Sheet.Activate?) is best to handle storing / restoring old
regime?
4. What method of storing these settings? Would SetSetting/GetSetting be ok
to use?

I might be on a wrong track so I better explain why I need it:

I want user to open my workbook application with menus / toolbars / sliding
bars / etc the way I designed them.
However, if user simultaneously wishes to open some other workbook or start
some blank new book, I need to give him what he usually has there - complete
with sliding bars, formula strip and usual customisation of a menu bar
(users do customise it, placing additional buttons to the right of Help menu
item, so that all handy stuff fits two rows).

TIA
Paul

You ask a lot<g

Use the following events in the thisworkbook module

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End Sub

Check out the following link
http://support.microsoft.com/default...&Product=xlw97
XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items"

Post back if you need help


--
Regards Ron de Bruin
http://www.rondebruin.nl


"count" wrote in message ...
Hi,
1. How to find out what are usual user's toolbars / menus / menus
rearrangements without actually opening new blank sheet?
2. How can I record customisations to the menu bar, so I can recreate them?
3. What event (Sheet.Activate?) is best to handle storing / restoring old
regime?
4. What method of storing these settings? Would SetSetting/GetSetting be ok
to use?

I might be on a wrong track so I better explain why I need it:

I want user to open my workbook application with menus / toolbars / sliding
bars / etc the way I designed them.
However, if user simultaneously wishes to open some other workbook or start
some blank new book, I need to give him what he usually has there - complete
with sliding bars, formula strip and usual customisation of a menu bar
(users do customise it, placing additional buttons to the right of Help menu
item, so that all handy stuff fits two rows).

TIA
Paul

You're right Ron :)
I'll split these questions into separate postings.
Thanks for the link
Paul
U¿ytkownik "Ron de Bruin" napisa³ w wiadomo¶ci
...
You ask a lot<g

Use the following events in the thisworkbook module

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End Sub

Check out the following link

http://support.microsoft.com/default...&Product=xlw97
XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items"

Post back if you need help


--
Regards Ron de Bruin
http://www.rondebruin.nl


"count" wrote in message
...
Hi,
1. How to find out what are usual user's toolbars / menus / menus
rearrangements without actually opening new blank sheet?
2. How can I record customisations to the menu bar, so I can recreate
them?
3. What event (Sheet.Activate?) is best to handle storing / restoring
old
regime?
4. What method of storing these settings? Would SetSetting/GetSetting be
ok
to use?

I might be on a wrong track so I better explain why I need it:

I want user to open my workbook application with menus / toolbars /
sliding
bars / etc the way I designed them.
However, if user simultaneously wishes to open some other workbook or
start
some blank new book, I need to give him what he usually has there -
complete
with sliding bars, formula strip and usual customisation of a menu bar
(users do customise it, placing additional buttons to the right of Help
menu
item, so that all handy stuff fits two rows).

TIA
Paul