Joined: 28 Jan 2003
Location: Wylie, Texas
To protect/hide the formula(s), right click on the cell or group of cell and select Format Cells. Click the Protection Tab and make sure that the "Locked" and "Hidden" boxes are selected and Click OK. Then go to Tool, Protection, Protect Sheet and enter a password. You must enter it twice. To protect the spreadsheet where the array is, go to Format, Sheet, and select Hide. Then go back to Tools, Protection, Protect Workbook and enter a password. That should do it unless I over simplified your question.