Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have used some VBA script that I obtained from John Walkenbach's website (specifically, http://j-walk.com/ss/excel/tips/tip48.htm) to provide users with a dialog box to choose a selection of worksheets to print, in my case using the modification under the link show that is suggested to ensure continuous page numbering. It works great. I have multiple user groups, however, and have a good idea of what different 'packs' these different user groups might want (that is, depending on their seniority/role, they may want the "Executive version", the "Full/Standard version", etc.. and the version choice should drive standardised, different worksheet selections). Can I adapt the script to pre-check only certain checkboxes, so that when the macro for the "Executive version" is run, say, the dialog box shows up as before but the user is just confirming rather than actively choosing a selection of worksheets? This way, at least they'll see/appreciate what they're not getting in choosing the more summary versions of the different 'packs' provided, which they wouldn't get if I wrote a standard macro to just print the relevant worksheet selection. Thanks in advance for any help Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Checkboxes | Excel Discussion (Misc queries) | |||
Checking and Unchecking CheckBoxes in code | Excel Discussion (Misc queries) | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
Checkboxes | Excel Discussion (Misc queries) |