I am developing a file that will need to be used by only 2 people at the same time but the file contains code and userforms.
The file will consist of the following sheets
Drivers Master List
Driver List
Availability Master List
Availability List
The initial data will be added via a userform into the Driver Master List which will only be performed by user 1. This data will be entered as text into the sheet and will be output on the Driver List in alphabetical order via formulas referencing the Driver Master List sheet.
User 2 will use a userform to assign dates to each driver which will be added as text to the Availability Master List which will be output on the Availability List sheet in alpha order, etc, etc.....
So I suppose my question is can the file be opened as read/write by the 2 users where both execute code to see updates flowing through the file?
TIA
The file will consist of the following sheets
Drivers Master List
Driver List
Availability Master List
Availability List
The initial data will be added via a userform into the Driver Master List which will only be performed by user 1. This data will be entered as text into the sheet and will be output on the Driver List in alphabetical order via formulas referencing the Driver Master List sheet.
User 2 will use a userform to assign dates to each driver which will be added as text to the Availability Master List which will be output on the Availability List sheet in alpha order, etc, etc.....
So I suppose my question is can the file be opened as read/write by the 2 users where both execute code to see updates flowing through the file?
TIA