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
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