Uncheck \View\Toolbars\...

[Guest]

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

 

[Guest]

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.

 

[Guest]

Thank you, Tom.
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.