| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. :) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. :) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
| Call user defined function in an add-in | Excel Programming | |||
| How to call a function of an user defined DLL from Excel? | Excel Programming | |||
| Excel "Insert Formula" dialog always call my user defined function | Excel Programming | |||
| User define function and dialog | Excel Programming | |||
Hybrid Mode
