S
Stuart
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 are:
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.
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 are:
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.