setting up linking workbooks-protections?

Soozie · May 24th, 2002, 01:31 PM

I have about 14 worksheets in one workbook. They are for different people, who only need to view/change their respective sheet. My thought was to copy each sheet to individual workbooks and passcode protect them.
Is there a way to set them up so that when they update their individual sheets, the master workbook gets updated? And vice versa-if the master workbook administrator makes any changes to the worksheets, then the individual ones should reflect those changes as well.
What a mouth full!

Corni · Jun 17th, 2002, 10:46 PM

What about having only 14 workbooks for the 14 different users, which could be protected for opening/modifying for all individual users and with full access for the administrator. That in the situation that there are serious reasons to prevent User1 for example of accessing the data in Book7. A very effective control with regard to the access permissions is in an Access database environment, where you could set up 14 tables and allocate selective permissions for different users.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 01:31 PM	#1
Soozie New Member Join Date: Feb 2002 Posts: 13	I have about 14 worksheets in one workbook. They are for different people, who only need to view/change their respective sheet. My thought was to copy each sheet to individual workbooks and passcode protect them. Is there a way to set them up so that when they update their individual sheets, the master workbook gets updated? And vice versa-if the master workbook administrator makes any changes to the worksheets, then the individual ones should reflect those changes as well. What a mouth full!

Jun 17th, 2002, 10:46 PM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	What about having only 14 workbooks for the 14 different users, which could be protected for opening/modifying for all individual users and with full access for the administrator. That in the situation that there are serious reasons to prevent User1 for example of accessing the data in Book7. A very effective control with regard to the access permissions is in an Access database environment, where you could set up 14 tables and allocate selective permissions for different users.