Protecting & Unprotecting all sheets.

Moradyn · Apr 18th, 2002, 03:04 PM

Evening all, I'd like to protect and unprotect a bunch of sheets in the same workbook, in one go. so just enter password and bam, all unprotected.

Now, i'm sure this isn't a new question

I've used search and found one by Nish, on his homepage, but i need a pw to use it i think, and no answer to email.

Anyone know a Link, to something already done to do this. ?

Regards

SamS · Apr 18th, 2002, 03:48 PM

Moradyn have a look at

http://www.mrexcel.com/wwwboard/messages/9671.html

Moradyn · Apr 18th, 2002, 04:28 PM

Can't seem to get this to work, any info on where to put it ?

I tried putting it into a form button, but got an expected end sub message.

Regards

Mora

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 03:04 PM	#1
Moradyn New Member Join Date: Apr 2002 Posts: 17	Evening all, I'd like to protect and unprotect a bunch of sheets in the same workbook, in one go. so just enter password and bam, all unprotected. Now, i'm sure this isn't a new question I've used search and found one by Nish, on his homepage, but i need a pw to use it i think, and no answer to email. Anyone know a Link, to something already done to do this. ? Regards

Apr 18th, 2002, 03:48 PM	#2
SamS Board Regular Join Date: Feb 2002 Location: Brisbane, Down Under Posts: 533	Moradyn have a look at http://www.mrexcel.com/wwwboard/messages/9671.html

Apr 18th, 2002, 04:28 PM	#3
Moradyn New Member Join Date: Apr 2002 Posts: 17	Can't seem to get this to work, any info on where to put it ? I tried putting it into a form button, but got an expected end sub message. Regards Mora