I have an Excel 2010 workbook with one sheet (call it sheet1) to which cells in other sheets are linked. I would like to protect the linked cells in the other sheets but if I do, then changes to the cells in sheet 1 are not made in the other sheets. One could unprotect the other sheets, make changes in sheet1, and protect the other sheets again. However, this workbook will be used by people who have only enough knowledge of Excel to input data in cells. Having to protect and unprotect will surely lead to errors. I am thinking that one solution would be to create a macro that would accomplish what needs to be done. I do not have the VBA skills to create such a macro but perhaps someone on this forum can and would be kind enough to share it.

There may be a simpler way to do this, but a macro that does the following would do the trick.

1. When run, the macro unprotects all password protected sheets. (The macro can quote the password.)
2. The macro makes sheet1 the active sheet.
3. The macro opens a user input box that says:
"Click on any cell in sheet1 and enter or change data in that cell, then press Enter."
4. The data is entered in that cell.
5. The macro password protects all the sheets that it had previously unprotected.
6. The macro makes active the sheet that was active before the macro was run.
7. The macro ends.

Any help or advice would be appreciated.

-- Arthur