Gary,

How about an add-in?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
would putting a userform in a separate workbook cause any issues in this
scenario? the workbook would only contain the form.

there are about 20 identical workbooks, with a sheet for each month. there
is only one workbook open at a time and only the manager enters data into
the workbook.

i was just thinking i could call the form from whatever workbook is open,
enter the data, save the workbook and then load the next workbook.
the form only enters data on the active sheet, so for ease of management,
just wondering if this is a viable solution.
--


Gary