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