Must I use IRM to protect an entire workbook?
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? |
Must I use IRM to protect an entire workbook?
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 On Tue, 11 May 2010 15:08:01 -0700, DonMark wrote: 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? |
All times are GMT +1. The time now is 04:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com