Hello-
I have a project where i would like each individual user to have his/her own spreadsheet that contains a UserForm. When the info is submitted from the form, I would like the info to be placed in the TaskData sheet in the individual workbook, as well as the TaskData sheet in a Master Workbook. It should then save the data and close the workbook. The Master workbook contains reports, charts, etc for my manager to run reports on the data. All workbooks are created identically and all are located in the same folder on a shared drive. The other part to this is that if the Master workbook is already open, how do I get the info to be added, without getting a "read-only" warning, etc.

When i run the macro shown below, the UserForm data is placed in the TaskData Sheet in the individual workbook, then it opens the Master workbook to attempt to place the data, as expected. But, instead of just placing the data, something is causing the UserForm to open in the Master Workbook, creating an error. Any ideas? Any help is greatly appreciated! Thanks much!

Please Login or Register  to view this content.