Hello,
I have a macro set on one of my workbooks. The file contains four-employee sheets and a dashboard. The criteria for the macros was that when an employee opens the sheet and inputs their password, that individual sheet will show up. It works; however, I am encountering an issue when all four employees simultaneously open the file and make changes.
There are reports of employees saying they cannot see their sheet; other times, employee one will see employee two-sheet and vice versa. Is there a workaround to this?
I have a macro set on one of my workbooks. The file contains four-employee sheets and a dashboard. The criteria for the macros was that when an employee opens the sheet and inputs their password, that individual sheet will show up. It works; however, I am encountering an issue when all four employees simultaneously open the file and make changes.
There are reports of employees saying they cannot see their sheet; other times, employee one will see employee two-sheet and vice versa. Is there a workaround to this?