much better!

it works real well...it's actually the way I wanted to do it in the
first place..just didn't know how to go about it..
thanks!


I now have a form where the user can select from a list of months and
then a button to generate some results based on this..

basically I'm generating worksheets for many people (let's say 20) for
the given month.

How hard would it be to be able to exclude certain people?
in other words I could have a menu where I sould select as many people
as I want. for example if I want to generate the workbooks for 3
people (not all 20) for any given month. I would click on their names
and the month I want and run my macros...

on the macro side I already have the code that handles each person
individualy.. I would just need to be able to pass the name of the
chosen persons (from the list in my form)

what would be the correct syntax for this?

thanks

PAbs


---
Message posted from http://www.ExcelForum.com/