Push updates from one workbook to others?

[ChrisP]

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!!!

 

[Pete_UK]

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