You can just record a macro while changing your view and then place in the
ThisWorkbook module under Workbook_open and workbook_close.

--
Don Guillett
SalesAid Software

"Michelle" wrote in message
...
I would like to either hide the tool bars when excel opens
then unhide them when it closes or make it open in full
screen then undo that when I close. Does anyone have the
code for this.