"Protect Sheet"

E

Edward

Apologies if this appears to some as a duplicated post. For some unknown
reason it hasn't shown in my listings.

I am using Excel 2007 with Vista Home Premium.

I have 15 workbooks, each with 12 sheets. I want each sheet (not the
workbook) password protected to prevent any accidental to interference with
formulae.

With a total of 180 worksheets I am a bit disappointed there is no way other
than protecting each sheet one at a time entering each password twice...!
......Or am I wrong? I sincerely hope I am.

Can anyone help?

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top