View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
count count is offline
external usenet poster
 
Posts: 64
Default 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