Excel 2000 - Worksheet Protection Problem

  • Thread starter Thread starter ksp
  • Start date Start date
K

ksp

I need to protect only certian cells on a worksheet that contai
formula's. I have selected the entire worksheet and 'unlocked' al
cells, then locked just those cells I wish to protect, then enabled th
worksheet protection. I still need the user to be able to hide / unhid
columns & rows for flexability when printing, however as soon as
enable the protection I can no longer hide / unhide columns & rows. A
I trying to do the impossible ?? Or am I just missing something simpl
?
 
Hi ksp!

You can allow hiding and unhiding of columns in Excel 2002 and 2003
but AFAIK this is not possible in Excel 2000.

My view would be to sacrifice protection as it is very weak anyway an
is cheaper than upgrading.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi

Create a report sheet for printing, where you get through links from
original sheet only data needed for printing, or where the whole original
sheet along with formatting is mirrored, leaving for user hiding/unhiding
rows and columns.
 
Hi,
I use VB in a Macro in Excel 97. This enables filters and
Outlining.
Sub Auto_Open()
Sheets("SheetName").EnableAutoFilter = True
Sheets("SheetName").EnableOutlining = True
Sheets("SheetName").Protect Password:="forecast",
contents:=True, userInterfaceOnly:=True
End Sub
Have fun.
Gary
 
Back
Top