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

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. :)

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. :)

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

On Jan 7, 9:23 am, "Peter T" <peter_t@discussions wrote:
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. :)

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?

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

office button and selects 'Send'

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

Regards,
Peter T

"R Tanner" wrote in message
...
On Jan 7, 9:23 am, "Peter T" <peter_t@discussions wrote:
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. :)

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?