I have a very in depth drill down model I did in a spreadsheet. This
spreadsheet has many buttons and checkboxes, which are hidden/unhidden
when rows are hidden/unhidden. When the workbook is closed a function
is called. This function unhides all rows and then unhides all
checkboxes and buttons. I would like to call this same function when
the user goes to the office button and sends the workbook. Otherwise,
all buttons/checkboxes are displayed when the workbook is sent, but
the rows are still hidden. i.e., the whole thing is screwed up. This
is going to upper management, so I have to try and safeguard stuff
like that. :)