How To Call A Function When A User Activates a Dialog Box

[R Tanner]

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.

 

[Peter T]

Could you explain the question

Regards,
Peter T

 

[R Tanner]

Could you explain the question

Regards,
Peter T

If a user goes to the office button and selects 'Send', an email is
opened allowing the user to send the activeworkbook as an attachment.
I want to run a function on that workbook before it is sent in the
email. How can I call that function via code when the user selects to
send the workbook as a PDF, XPS, or email?

 

[Peter T]

office button and selects 'Send'

Where is that, do you mean File/SendTo/more options

Regards,
Peter T