Hi, I hope you may be able to advise, i have looked at other threads but couldn't see a similar post, so here goes.
I have an Excel workbook, with multiple worksheets and a user form for others to select the worksheet they want. The worksheets are hidden and the VBA code in the command buttons on the Userform unhides the sheet they need.
My issue is, when two or more people open the file up, editing is fine, but when they select another worksheet on the UserForm it will also change the other persons views. For example is User one is looking at worksheet A, User two is looking at worksheet B, if User A then chooses to look at worksheet C (using a command button on the userform) it will change the view of User two to worksheet C, the same as User A selection.
Has anyone got any suggestions on how i could solve this?
I have an Excel workbook, with multiple worksheets and a user form for others to select the worksheet they want. The worksheets are hidden and the VBA code in the command buttons on the Userform unhides the sheet they need.
My issue is, when two or more people open the file up, editing is fine, but when they select another worksheet on the UserForm it will also change the other persons views. For example is User one is looking at worksheet A, User two is looking at worksheet B, if User A then chooses to look at worksheet C (using a command button on the userform) it will change the view of User two to worksheet C, the same as User A selection.
Has anyone got any suggestions on how i could solve this?