Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to present User with Print Options
Say I present a form with a listbox asking 2 questions:
Do you want to print every sheet in every workbook? (whose full paths are already in a string array named PrintFileNames) and Do you want to hide the same columns in every book and sheet that you will print out? For Q1, Global_PrintAllBooks_Sheets will be set to True or False. For Q2, Global_HideSameCols, the same. If the results a Global_PrintAllBooks_Sheets = True Global_HideSameCols = False how best to ask user which (if any) columns they wish to hide in each workbook/sheet? I've been trying to set 'global' variables for options that will apply to all books and sheets, then 'Wkbk' variables for options applying to all workbooks, then finally 'Sht' variables for worksheet level options. This seems complicated (and certainly confusing). How do I tackle something like this, please, bearing in mind that there are other questions to be asked, and thus to further complicate things? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Security - customize field options based on user accou | Excel Discussion (Misc queries) | |||
print area options | New Users to Excel | |||
How to set DEFAULT print options in Excel to print gridlines? | Excel Discussion (Misc queries) | |||
print options | Excel Discussion (Misc queries) | |||
How to extend user options | Excel Programming |