| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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.  |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Could you explain the question
Regards, Peter T "R Tanner" <(E-Mail Removed)> wrote in message news:71bfca3e-8c9f-4188-b3b2-(E-Mail Removed)... >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. |
|
|
|
|
|||
|
Guest
Posts: n/a
|
On Jan 7, 9:23 am, "Peter T" <peter_t@discussions> wrote:
> Could you explain the question > > Regards, > Peter T > > "R Tanner" <tanner.ro...@gmail.com> wrote in message > > news:71bfca3e-8c9f-4188-b3b2-(E-Mail Removed)... > > >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? |
|
|
|
|
|||
|
Guest
Posts: n/a
|
> office button and selects 'Send'
Where is that, do you mean File/SendTo/more options Regards, Peter T "R Tanner" <(E-Mail Removed)> wrote in message news:c108608e-248c-4a9f-9a96-(E-Mail Removed)... > On Jan 7, 9:23 am, "Peter T" <peter_t@discussions> wrote: >> Could you explain the question >> >> Regards, >> Peter T >> >> "R Tanner" <tanner.ro...@gmail.com> wrote in message >> >> news:71bfca3e-8c9f-4188-b3b2-(E-Mail Removed)... >> >> >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? |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | SteveM | Microsoft Excel Programming | 1 | 3rd Jan 2008 03:45 PM |
| Call user defined function in an add-in | =?Utf-8?B?RGFsZSBGeWU=?= | Microsoft Excel Programming | 2 | 15th Dec 2006 05:04 PM |
| Excel "Insert Formula" dialog always call my user defined function | nicolas.gendron@gmail.com | Microsoft Excel Programming | 0 | 1st Mar 2006 02:35 AM |
| VB activates unwanted function | Urban | Microsoft Excel Programming | 3 | 6th Jul 2004 06:59 PM |
| Error:0x80040707;dll function call crashed;Wait on dialog | =?Utf-8?B?d21o?= | Windows XP Help | 0 | 7th Jan 2004 01:41 AM |
