Show userform for certain workbooks
Posted by Rhona on February 16, 2001 3:56 AM
I have a group of about 100 workbooks containing project details within my organisation all with names in the format DTDxxxx.xls. In one of these workbooks I have created a userform which accepts various data e.g. details of costs, project managers comments which are then written to a protected and hidden sheet within the workbook to serve as an audit trail. Now the form and the macros I've used work fine in the one workbook but I'd like the form to be shown every time a user saves any project workbook (i.e. beginning with DTD). I don't want to have to copy the form and macros to every existing project workbook or have to add it to any new ones, just have something running in the background which will show the form automatically.
Thanks in advance to anyone who can help,