LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default Pre-checking checkboxes in a dialog box


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Checkboxes ppidgursky Excel Discussion (Misc queries) 0 April 7th 09 07:24 PM
Checking and Unchecking CheckBoxes in code Ayo Excel Discussion (Misc queries) 0 April 3rd 09 08:41 PM
Spell Checking with checking cell notes jfitzpat Excel Discussion (Misc queries) 0 August 8th 07 10:26 PM
How to delete the "Insert Function Dialog Box" (dialog box only)? TBI''d biker Excel Worksheet Functions 2 April 7th 07 09:18 PM
Checkboxes chuck Excel Discussion (Misc queries) 1 January 25th 05 03:48 AM


All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"