50 workbooks

[Peter in Rosburg]

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

 

[Tom Ogilvy]

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.