Excel help please

Gers

I have a large spreadsheet which contains approx 20 worksheets.  Currently I have one of these worksheets set as the master to which most of the others take information via formulas. (these are dates and days)  I would like this master worksheet to be unable to be changed by others -  it all gets emailed to someone else to complete details every month and this person is not remotely IT literate.

Is it possible to lockdown this one worksheet please, and if so, how?

Thanks

WaywardDriver

Right-click the master worksheet tab then either Hide or Protect Sheet with a password.

Gers

WaywardDriver said:

Right-click the master worksheet tab then either Hide or Protect Sheet with a password.

Perfect - thanks so much! 

Heedtheadvice

Alternatively move the master sheet to another (new) workbook. The formula linking can happen between books as well as sheets.

If the sheets (20 of them) were to go to different people then they to could all be on separate workbooks too -although not applicable in your case.

If the person filling in your data is not IT literate then I would suggest further measures such as locking all the cells in the sheets that do have bits populated -except for those that will be required to be filled in;

similarly protecting the layout of the sheets and that of the workbook to prevent other corruptions, and turn on sharing and change tracking too. You mind have to learn a bit more to do that?

If it is important I would either just send new sheets that only hold the data cells required to enable completion of even use another method (I have presumed you email or similarly send the whole sheets back and forth.

edit: Did I mention keeping a master separately and backing up