HOW TO PASSWORD PROTECT SHEET?

[monis]

Hi,

I have an excel file containing a number of sheets, I will name them sheet 1,2,3,4 and 5.

The issue I have is this.

Sheet 1 need to be restricted access. Only certain people can view / edit as they contain sensitive data. Sheets 2, 3,4 and 5 are open access and can be viewed by anyone.

Is there a way of password protecting that only certain people can access sheet 1.

Thanks

[HansV]

If you want strict security, an Excel workbook is not the correct tool. It is easy for someone who knows Excel and VBA to break the protection.