Worksheet Protection

E

Ed O'Brien

I have a workbook with 11 password protected worksheets. The worksheets are
linked via various formulae so their names are extremely important for their
functions to work.

Can anyone tell me if it is possible to password protect the names of the
worksheets as well as the contents?

Ed
 
B

Bob Phillips

You could use the worksheet codename if working from VBA, then it doesn't
matter if the sheet name gets changed.

This would then be

Sheet1.Range("A1").Value

instead of

Worksheets("Sheet1").Range("A1").Value

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
E

Ed O'Brien

No VBA here, Bob. I haven't a clue in that area. Its only important if a
user decides he/she doesn't like the name and decides to change it against
instructions.

Ed
 
B

Bob Phillips

Don't think you can do anything without VBA here.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
E

Ed O'Brien

Okay, thanks Bob. That would be too steep a learning curve for me. I'm
nearly 70 so I doubt I'd survive long enough!!

Best wishes,

Ed
 
D

Dave Peterson

You can protect the workbook's structure:
tools|protection|protect workbook
and check Structure.

Be aware that this kind of protection is easily broken (as is worksheet
protection!).

But if your formulas are within the same workbook, they're going to update when
the worksheet name changes, right??? So are you sure there's a problem?
 
E

Ed O'Brien

Didn't cross my mind, Dave, so I didn't try it. Changing the names of the
sheets makes no difference. As you say, they update themselves so all
formulae remains effective.

Many thanks.

Best wishes,

Ed
 
E

Earl Kiosterud

Ed,

Changing sheet names shouldn't mess up your formulas, even if they refer to
cells in other sheets. The formulas will be automatically changed to
reflect the new sheet name, and should continue to work.

Protecting the workbook (Tools - Protection - Workbook (not worksheet)) will
disallow changing worksheet names (as well as moving or deleting
worksheets.) You can supply a password to the workbook protection.
Worksheet protection protects the innards of a sheet (cell contents and
stuff), and workbook protection protects the workbook (moving, deleting,
renaming worksheets, etc.) You can apply both levels of protection.

Earl Kiosterud
www.smokeylake.com
 
E

Ed O'Brien

Thanks, Earl. I'm okay with just protecting the sheets (cell groups) in this
instance but I've stored the info on workbooks in case it comes in handy at
some time in the future.

Regards,

Ed
 
Top