Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Push updates from one workbook to others?
I have a master workbook and 5 different workbooks that have links to the
master workbook. I have to password protect my master workbook as it has salaries and not everyone should be allowed to see those. I would like to make an update to the master workbook and have the update be "pushed down" into the other workbooks, can this be done? I don't want users to open the workbooks and select update because they then need to know the password to the master workbook, which would mute the point of having the master workbook being password protected. Thanks!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Push updates from one workbook to others?
You can't do that with a formula, as a formula can only affect the
cell in which it is located. However, you should be able to do it with a macro located within the master workbook, so that your other employees do not have access to it. You might like to post in the .programming group, but you will need to give more details about how your sheets are laid out. Hopt this helps. Pete On Jul 11, 4:30*pm, ChrisP wrote: I have a master workbook and 5 different workbooks that have links to the master workbook. I have to password protect my master workbook as it has salaries and not everyone should be allowed to see those. I would like to make an update to the master workbook and have the update be "pushed down" into the other workbooks, can this be done? I don't want users to open the workbooks and select update because they then need to know the password to the master workbook, which would mute the point of having the master workbook being password protected. Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook updates | Excel Discussion (Misc queries) | |||
Workbook updates | Excel Discussion (Misc queries) | |||
Help with workbook updates | Excel Worksheet Functions | |||
linked workbook updates | Excel Worksheet Functions | |||
Trying again for workbook formula updates | Excel Worksheet Functions |