software

I am using columns A-L with content. I want certain cols to be protected
as they bring inthe dynamic content.

Firstly, I selected the whole worksheet [ctrl a], right clicked and
took the tick out of Locked, I then highlighted the whole of cols G, H,
I amp; K by clicking on the column letter and checked the Locked box. I
then highlighted the whole of row 1 as this is the column headers and I
have auto-filter running and unchecked the Locked box. Then I applied
the protection so the cells can't be changed.

But now the auto-filter won't work. Is this a known problem with
Excel?

I'm using Excel 2000 [9.0.2720]

Ta
Ian--
iwgunter
------------------------------------------------------------------------
iwgunter's Profile: www.excelforum.com/member.php...oamp;userid=15441
View this thread: www.excelforum.com/showthread...hreadid=513526Hi

You will need to put protection on, with the userinterface still set to
True.
Enter some code like the following into a standard module of your
Workbook to invoke the Protection.
Change the quot;mypasswordquot; to whatever you want.

Sub Protectsheet()
With ActiveSheet
.EnableAutoFilter = True
.Protect Password:=quot;mypasswordquot;, DrawingObjects:=True, _
contents:=True, Scenarios:=True, UserInterfaceOnly:=True
End With
End Sub

Sub UnProtectSheet()
With ActiveSheet
.Unprotect Password:=quot;mypasswordquot;
End With
End Sub

You can copy the code I posted and paste it into your Visual Basic
Editor
(VBE) in a Standard Module located in your project (workbook). Shortcut
keys would be ..

Alt F11 (open VBE)
Ctrl R (open Project Explorer)
Select Workbook on left
If no modules exist:
Insert | Module
Paste code in Module
If modules exist:
Double click desired module
Paste code in Module
Add further code if requiredClick on the Excel icon at top left of the
VB Editor to return to the Worksheet.

I usually add shortcut keys to the macros for my own use.
Toolsgt;Macrogt;Macrosgt;Select Protectsheetgt;Options and enter a letter code
in the box
Repeat for the Unprotect macro.

Then you can quickly switch protection on and off for yourself with
these shortcuts.
--
Regards

Roger Govierquot;iwgunterquot; gt; wrote
in message ...
gt;
gt; I am using columns A-L with content. I want certain cols to be
gt; protected
gt; as they bring inthe dynamic content.
gt;
gt; Firstly, I selected the whole worksheet [ctrl a], right clicked and
gt; took the tick out of Locked, I then highlighted the whole of cols G,
gt; H,
gt; I amp; K by clicking on the column letter and checked the Locked box. I
gt; then highlighted the whole of row 1 as this is the column headers and
gt; I
gt; have auto-filter running and unchecked the Locked box. Then I applied
gt; the protection so the cells can't be changed.
gt;
gt; But now the auto-filter won't work. Is this a known problem with
gt; Excel?
gt;
gt; I'm using Excel 2000 [9.0.2720]
gt;
gt; Ta
gt; Ian
gt;
gt;
gt; --
gt; iwgunter
gt; ------------------------------------------------------------------------
gt; iwgunter's Profile:
gt; www.excelforum.com/member.php...oamp;userid=15441
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=513526
gt;
If you already have the outline/subtotals applied, you can protect the worksheet
in code (auto_open/workbook_open??).

Option Explicit
Sub auto_open()
With Worksheets(quot;sheet1quot;)
.Protect Password:=quot;hiquot;, userinterfaceonly:=True
'.EnableOutlining = True
.EnableAutoFilter = True
End With
End Sub

It needs to be reset each time you open the workbook. (excel doesn't remember
it after closing the workbook.)

If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm

iwgunter wrote:
gt;
gt; I am using columns A-L with content. I want certain cols to be protected
gt; as they bring inthe dynamic content.
gt;
gt; Firstly, I selected the whole worksheet [ctrl a], right clicked and
gt; took the tick out of Locked, I then highlighted the whole of cols G, H,
gt; I amp; K by clicking on the column letter and checked the Locked box. I
gt; then highlighted the whole of row 1 as this is the column headers and I
gt; have auto-filter running and unchecked the Locked box. Then I applied
gt; the protection so the cells can't be changed.
gt;
gt; But now the auto-filter won't work. Is this a known problem with
gt; Excel?
gt;
gt; I'm using Excel 2000 [9.0.2720]
gt;
gt; Ta
gt; Ian
gt;
gt; --
gt; iwgunter
gt; ------------------------------------------------------------------------
gt; iwgunter's Profile: www.excelforum.com/member.php...oamp;userid=15441
gt; View this thread: www.excelforum.com/showthread...hreadid=513526

--

Dave Peterson