User forms in a Collaborative environment

[Rebmit]

Good Morning,

I wonder if you can advise please? I have an excel workbook which has >100 sheets (one for each persons information) which is controlled from a User Form. All the sheets are hidden until the user clicks on their button on the user form. This function works well and as it is in a collaborative workspace all users can enter the file at the same time. However the issue is when someone else clicks on their button it changes the view for everyone. I want the the sheet the person opened to remain and not change when someone else click on another name. Hopefully that makes sense? The code i have for the persons button on the user form is.

Private Sub CommandButton181_Click()
Worksheets("Rebmit").Visible = True
Worksheets("Home").Visible = True
Homeform.Hide
ExitForm.Show
Sheets("Remibt").Select
ActiveWindow.Zoom = 60
ActiveWindow.ScrollRow = 1 'the row you want to scroll to
ActiveWindow.ScrollColumn = 1 'the column you want to scroll to
'hides all the worksheets
Dim Wrksheet As Worksheet
For Each Wrksheet In ThisWorkbook.Worksheets
If Wrksheet.Name <> ThisWorkbook.ActiveSheet.Name Then
Wrksheet.Visible = xlSheetVeryHidden
End If
Next Wrksheet
End Sub

Im no expert so if there is any advise i would really appreciate it.

Regards

Reb