Posted to microsoft.public.excel.programming
|
|
Uncheck \View\Toolbars\...
Thank you, Tom.
cg
"Tom Ogilvy" wrote:
See Chip Pearson's overview of events
http://www.cpearson.com/excel/events.htm
you would probably want to use the Workbook_Open and Workbook_Beforeclose
events.
turn on the macro recorder and go to View=Toolbars, then select your
toolbars.
Turn off the macro recorder.
That should give you some sample code for making commandbars visible and
hiding them.
--
Regards,
Tom Ogilvy
"hccatmo" wrote:
I'd like to have certain options when do
View
Toolbars
to be unchecked upon open the work book and
to checked upon closing the workbook.
Can I do that?
Thx.
cg
|