Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I lock specific cells w/o having to protect entire sheet? | Excel Worksheet Functions | |||
Name an Entire Workbook | Excel Discussion (Misc queries) | |||
need to lock 5 cells but not protect entire sheet | Excel Discussion (Misc queries) | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
how do I protect formula's only, not entire sheet or book? | Setting up and Configuration of Excel |