Lock down a wokbook
 

Hi...

I have a 32 sheet workbook that my users input quite freely. However, when
they have completed their input I want to hit a button that will freeze all
data and refuse any more changes/user input. I'd use protect workbook but the
book is intricate and changing all the cell properties would be a nightmare...

Thanks in advance G

Lock down a wokbook
 

Select all the cells on the worksheet (Ctrl-A a few times--depending on what
version of excel you're running) and then format|cells|protection tab.

Check the Locked box.

Then protect that worksheet--not the workbook.
tools|protection|protect sheet

Be aware that this kind of worksheet protection is easily broken.

Gordon wrote:

Hi...

I have a 32 sheet workbook that my users input quite freely. However, when
they have completed their input I want to hit a button that will freeze all
data and refuse any more changes/user input. I'd use protect workbook but the
book is intricate and changing all the cell properties would be a nightmare...

Thanks in advance G

--

Dave Peterson

Lock down a wokbook
 

Sub LockWorksheets()
Dim sh as Worksheet
for each sh in ActiveWorkbook.worksheets
sh.Cells.Locked = True
sh.Protect
Next

ActiveWorkbook.Save

End Sub

--
Regards,
Tom Ogilvy

"Gordon" wrote in message
...
Hi...

I have a 32 sheet workbook that my users input quite freely. However, when
they have completed their input I want to hit a button that will freeze
all
data and refuse any more changes/user input. I'd use protect workbook but
the
book is intricate and changing all the cell properties would be a
nightmare...

Thanks in advance G