Menus
If you are customizing the existing worksheet menu bar, then just don't
remove the controls you want to retain.
If you are building new "worksheet menu bar", then just add the standard
controls you want to use.
--
Regards,
Tom Ogilvy
"TK" wrote in message
...
Hi:
In an effort to make a workbook less intimidating
I would like to make invisible (actually removed not
dimmed) all Toolbars including the Worksheet Menu Bar
and Formula Bar when a workbook is opened then display
a customized Worksheet Menu Bar and Standard Menu Bar.
At the workbook close I world like to restore (not reset)
the users menu setup.
I know how to add and delete Worksheet Menu Items and
create toolbars with VBA but isn't there a way to use or retain
and use the basics such as File/save and Tools/Spelling without
writing code or macros for each one.
Thanks
TK
|