Hello,
I am trying to create an excel file that will be shared with another user. I need the user to select certain responses on one of three sheets in the same workbook.
I have 3 tabs named "Full View" "Customer View" and "Product View" all showing the same information but in different formats. I want the user to have the option of using any of the three views to begin writing in their responses. Once they start writing in one sheet, I want the other two to lock automatically to avoid having responses on multiple tabs.
Is there a VBA script that can be used to help with something like this?
Thank you!
-Matt
I am trying to create an excel file that will be shared with another user. I need the user to select certain responses on one of three sheets in the same workbook.
I have 3 tabs named "Full View" "Customer View" and "Product View" all showing the same information but in different formats. I want the user to have the option of using any of the three views to begin writing in their responses. Once they start writing in one sheet, I want the other two to lock automatically to avoid having responses on multiple tabs.
Is there a VBA script that can be used to help with something like this?
Thank you!
-Matt
