Locking Pages and/or Workbook

[AndrewWoodard]

Hello, Everyone!

I hope this is the appropriate area to post this. If not, pleas
forgive.

I have an Excel 2010 workbook I want to share with others. It is full o
data (all text or just numbers, but no numeric calculations) an
hyperlinks to either other sheets in the same workbook or hyperlinks t
PDF files I keep in a subdirectory off my C:\ drive.

What I want to be able to do is allow others to see the data, move fro
sheet to sheet, hyperlink to the PDFs and see those, etc. but NOT alte
any data or hyperlinks (no changing, adding, deleting, etc.).

It seems to me that protecting the workbook isn't the function I want
and there is no way to protect all sheets in one motion (I would have t
individually protect every sheet, and there are LOTS). This becomes
bigger task since I would need to unprotect everything and mak
additions or changes frequently, and then re-protect everything to mak
it safe for others to use again. (I hope this makes sense.)

ANY help, suggestions or prayers appreciated!

Andrew...

 

[Gord Dibben]

How about saving a copy as "Read Only" and making that public?

On the other hand, Protecting/Unprotecting many sheets can be done
easily with code if all sheets have the same password.

Sub ProtectAllSheets()
Application.ScreenUpdating = False
Dim N As Single
For N = 1 To Sheets.Count
Sheets(N).Protect Password:="justme"
Next N
Application.ScreenUpdating = True
End Sub

Sub UnprotectAllSheets()
Application.ScreenUpdating = False
Dim N As Single
For N = 1 To Sheets.Count
Sheets(N).Unprotect Password:="justme"
Next N
Application.ScreenUpdating = True
End Sub

You woild have to "Lock project from viewing" so's others could not
see the code and password.

Gord