SharePoint & file with code/userforms

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,625
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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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