More toolbars questions
 

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

More toolbars questions
 

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

More toolbars questions
 

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