rbscott1989
New Member
- Joined
- Apr 25, 2019
- Messages
- 9
Hello,
I am having an issue that I can't seem to find a solutionto. I have 2 separate excelworkbooks. The main workbook containsseveral worksheets that are all linked to one worksheet (WIZARD). That worksheet is then linked to a user form(COMPANY SAT REQUEST). On one workbook Ihave it to where the user form works throughout the entire workbook. However, 1 the file size is too large and 2 Iwant to restrict the users from accessing the rest of the worksheets.
What I want to be able to do is have a separate workbookwith just the user form and then when the user makes updates the data is pulledto the correlating workbook with the user form which allows the data to bedistributed across the rest of the workbook. Essentially I just want to mirror whatever the user puts on the form.
In the form I have several drop down lists and checkboxes. I want everything to include thecheck box values to copy over. Can thiseven be done?!
Any help you gurus can offer is greatly appreciated!
Ryan
I am having an issue that I can't seem to find a solutionto. I have 2 separate excelworkbooks. The main workbook containsseveral worksheets that are all linked to one worksheet (WIZARD). That worksheet is then linked to a user form(COMPANY SAT REQUEST). On one workbook Ihave it to where the user form works throughout the entire workbook. However, 1 the file size is too large and 2 Iwant to restrict the users from accessing the rest of the worksheets.
What I want to be able to do is have a separate workbookwith just the user form and then when the user makes updates the data is pulledto the correlating workbook with the user form which allows the data to bedistributed across the rest of the workbook. Essentially I just want to mirror whatever the user puts on the form.
In the form I have several drop down lists and checkboxes. I want everything to include thecheck box values to copy over. Can thiseven be done?!
Any help you gurus can offer is greatly appreciated!
Ryan