More toolbars questions

[count]

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

 

[Ron de Bruin]

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.aspx?scid=kb;en-us;166755&Product=xlw97
XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items"

Post back if you need help

 

[count]

You're right Ron
I'll split these questions into separate postings.
Thanks for the link
Paul