Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Header/Footer w/ Worksheet Option Buttons
I have a workbook named QUOTES that uses a referenced add-in workbook named
Add-In which contains all code to manipulate QUOTES. I have 2 option buttons on Sheet1 in QUOTES. One named optAdTech and the other optFormetco. These option buttons represent two different companies. I need to change the Header and Footer information to whichever company option button is true when the quote is printed in the BeforePrint Event in QUOTES. What is the best way to do this? Note: Left Header is company logo, Right Header is company address, Center Footer is text. Would it be possible to save the AdTech's header/footer information and Formetco's header/footer information in the Add-In and then apply it in QUOTES? For example: Private Sub Workbook_BeforePrint(Cancel As Boolean) Select Case True Case optAdTech ' call AdTech header/footer data from add-in Case optFormetco ' call Formetco header/footer data from add-in End Select End Sub -- Cheers, Ryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Header/Footer w/ Worksheet Option Buttons
Check your other post.
Ryan H wrote: I have a workbook named QUOTES that uses a referenced add-in workbook named Add-In which contains all code to manipulate QUOTES. I have 2 option buttons on Sheet1 in QUOTES. One named optAdTech and the other optFormetco. These option buttons represent two different companies. I need to change the Header and Footer information to whichever company option button is true when the quote is printed in the BeforePrint Event in QUOTES. What is the best way to do this? Note: Left Header is company logo, Right Header is company address, Center Footer is text. Would it be possible to save the AdTech's header/footer information and Formetco's header/footer information in the Add-In and then apply it in QUOTES? For example: Private Sub Workbook_BeforePrint(Cancel As Boolean) Select Case True Case optAdTech ' call AdTech header/footer data from add-in Case optFormetco ' call Formetco header/footer data from add-in End Select End Sub -- Cheers, Ryan -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
don't want to have to change font in header and footer each time? | Excel Worksheet Functions | |||
Change Header & Footer Info w/ Worksheet Option Buttons | Excel Discussion (Misc queries) | |||
page number other than the header footer option | Excel Discussion (Misc queries) | |||
VB. NET Code to Change Excel Worksheet Header/Footer. | Excel Programming | |||
How to add tool buttons in custom header & footer dialog box? | Setting up and Configuration of Excel |