"Protect Sheet"

**Edsaid** · 02-26-2009, 02:29 PM

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 interference with
formulae.

With a total of 180 worksheets I am a bit disappointed there is no way of protecting each sheet other than by entering each password - twice - one at a time!

.....Or am I wrong? I sincerely hope I am.

Can anyone help?

TIA

**Dunc3142** · 02-26-2009, 03:10 PM

Might be what you are looking for.

**Edsaid** · 02-26-2009, 03:52 PM

Thanks, Dunc...

I gave it a try but I've never even looked at VB let alone used it. I got to pasting the script but then could not figure what to do next. Is there any chance you can give me a walk-through?

Ed

**martindwilson** · 02-26-2009, 04:03 PM

or simpler
just to protect all sheets in workbook

Please Login or Register  to view this content.

**Edsaid** · 02-26-2009, 05:20 PM

Thanks a lot...

I'm afraid I'm a complete dummy when it comes to this sort of sophistication. I get so far but I'm at a loss what to do next. I keep getting it wrong, and can't get past this... (VB1.jpg image) attached.

**martindwilson** · 02-26-2009, 05:26 PM

cant help you there! some blasted 2007 thing!
well i can, you need them to be xlsm to do macros, darn stupid really, but hey -ho such is life

**shg** · 02-26-2009, 05:27 PM

In Excel 2007, you have to save workbooks with macros as macro-enabled workbooks. Follow the instructions in the picture you posted.

**Edsaid** · 02-26-2009, 06:38 PM

Thank you, my friends. I will press on using your advise. I will let you you know how I get on.

BTW, the "instructions" say nothing about saving in .xlsm, where or how, and only being self taught, it would have taken me forever to work it out, but thanks anyway.

Ed

**Edsaid** · 02-27-2009, 05:52 AM

Hi,

All working fine using martindwilson's script. Script from Dunc had an 'error'. Something to do with incorrect ending! Only minor, I bet, but not so minor for my little brain!!

Thanks again everybody.

Ed