50 workbooks
 

I am setting up 50 workbooks for 50 users on a network folder. The users
input there workload estimate information. All of the inputs are summarized
into a 51st workbook.

I am setting up 50 workbooks so any individual user can open their workbook
without interfering with other users. Each of the 50 workbooks has a
UserForm and some other code. The UserForm and code are identical in each
workbook.

After the users gain some experience with the application I am sure changes
will be required. Is there any way I can keep the code on a single code
workbook so I don't have to paste changes in all 50 workbooks?

Thanks, Peter

50 workbooks
 

Put your code in an addin rather than in 50 workbooks. Then in each
workbook and set a reference to your addin or have the users go into tools
=addins and select it to be loaded each time excel is opened.

--
regards,
Tom Ogilvy

"Peter in Rosburg" wrote in message
...
I am setting up 50 workbooks for 50 users on a network folder. The users
input there workload estimate information. All of the inputs are
summarized
into a 51st workbook.

I am setting up 50 workbooks so any individual user can open their
workbook
without interfering with other users. Each of the 50 workbooks has a
UserForm and some other code. The UserForm and code are identical in each
workbook.

After the users gain some experience with the application I am sure
changes
will be required. Is there any way I can keep the code on a single code
workbook so I don't have to paste changes in all 50 workbooks?

Thanks, Peter