Must I use IRM to protect an entire workbook?

D

DonMark

I'm trying to protect an entire workbook so that the forumlae will be hidden
from view. I would rather not protect each individual sheet, using a
password for each sheet. However when I try to use the Protect Workbook I'm
taken to sign up for IRM and I don't know why I must? Is there no way to
protect an entire workbook with one password with out signing up for IRM?
 
G

Gord Dibben

Protecting the workbook does nothing to protect cells on the sheets.

Workbook protection merely protects from changing structure or windows.

e.g. you cannot insert or delete sheets when workbook is protected.

That must be done by protecting each sheet.

You can protect all sheets with one password by using VBA

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top