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

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

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