View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default How To Call A Function When A User Activates a Dialog Box

Could you explain the question

Regards,
Peter T

"R Tanner" wrote in message
...
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. :)