Is there a way I can password protect a worksheet in a workbook from opening?
Not from being edited but from opening. I have a workbook which contains some
sheets with public information and one or two sheets with confidential
information. I would love to be able to password protect the confidential
worksheets from opening while the other sheets can be left alone and be
viewed as needed. Currently I am creating and distributing two separate
workbooks to our users; one with the confidential sheets and the other
without them. We are working with Excel 2002 and 2003. I look forward to any
help on this.

Thanks,
Lauren