-----Original Message-----
Yes, that sounds reasonable, depending on the pull-down
items that would appear on the form. If they'll be
different for each sub-category then your approach sounds
fine. If they'll be the same for each subcategory, you
might want to consider putting the sub-category as a
choice on the (one) form, so "Print Options" would
bring up the dialog.

__________________________________________________ ________
Ok, I think I like this idea of a dialog box you mentioned
here. Are you saying that I could have a 2nd level menu
that would bring a dialog box that I could put some
selections on it?

Right now, I have a level 2 menu, which has a title "Go
to/Print". Level 3 has 6 different items on it that are
presently under construction. Think of the level 3 items
as subcategories in which several print jobs can be
derived from within each subcategory. What happens if you
click one of those level 3 menu items, is it goes to a
page. Here on this page, there may be three or four
possible reports right under each other on this sheet.
Right now, I have set up a button to allow the user to
click to print that particular report, or they can click a
2nd button beside that to print two or more reports as the
case may be that are on the particular page. Each print
has a macro named print_xyz1, print_xyz2 etc.

I know this sounds inefficient and otherwise just lacks
<pzazz. I just need someone to get me started with some
code that might allow for manageing all these reports that
I print each month a little easier. In summary for the
sake of discussion, there are six different subcategories
with each subcategories having two or more separate print
ranges to print each month.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk