OMG!!!! Thank you!!! AWESOME AWESOME AWESOME!!!! The keystrokes I am going
to save!!!! Thanks!
--
-CRM


"Dave Peterson" wrote:

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Short course:

Open your workbook.
Hit alt-f11 to get to the VBE (where macros/UDF's live)
hit ctrl-R to view the project explorer
Find your workbook.
should look like: VBAProject (yourfilename.xls)

right click on the project name
Insert, then Module
You should see the code window pop up on the right hand side

Paste the code in there.

And while you're in the VBE...
select your poject
Tools|VBAProject Properties|Protection tab
Give it a memorable password.

It'll make finding the password a little more difficult--keep prying eyes out of
your code!

saltnsnails wrote:

Thank you but I don't know what to do with that? Where do I enter it? How
do I use it? I am still kind of new to this stuff. Thanks!
--
-CRM

"Dave Peterson" wrote:

Option Explicit
Sub UnprotectAll()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.unprotect password:="topsecret"
next wks
End Sub
Sub ProtectAll()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.protect password:="topsecret"
next wks
End Sub



saltnsnails wrote:

I would say that I am a moderate user of Excel and I need some help with
running a Macro. I have a workbook that has about 60 pages in it that
several people have access to in order to edit information on each of the
sheets. Each sheet has a Vlookup table that I am constantly modifying to
keep items current. My problem is that I am unlocking worksheets all day
long. The password is the same on all of the sheets. Is there a simple
macro I can run to unlock the entire workbook rather than individually
unlocking each sheet? And the same thing when I am finished and putting the
file back. Can I run a macro to reassign the password protection on all of
the sheets in the workbook? Thanks!
--
-CRM

--

Dave Peterson


--

Dave Peterson