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