SharePoint & file with code/userforms

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,632
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top