Hi Everyone,
i am trying to create & save an excel sheet in one drive or a teams group accessible to multiple users. the multiple users can go in and book seats for themselves. i tried using the VBA code, but the problem faced is that in my workstation the code works but in other users workstations the sheet runs like a simple excel.
i am looking for a solution on excel to autolock the cell after data entry by any of the user so that other person cannot overwrite on same.
Request your help!
i am trying to create & save an excel sheet in one drive or a teams group accessible to multiple users. the multiple users can go in and book seats for themselves. i tried using the VBA code, but the problem faced is that in my workstation the code works but in other users workstations the sheet runs like a simple excel.
i am looking for a solution on excel to autolock the cell after data entry by any of the user so that other person cannot overwrite on same.
Request your help!