Macro - Password

[Curious-George]

Hi All

I'm using a macro to protect a selection of cells within multiple identical work sheets.

I noticed only the original sheet that the macro is recorded on is protect with the actual password, the other sheets are protect but no password is needed to unprotect them.

Is there away round this? what am i doing wrong?

P.s. i'm a newb this is the first macro i have ever run

Any thoughts appreciated

Thanks

[HaHoBe]

Hi, Curious-George,

show us what you have?

Please Login or Register  to view this content.

And you should alter the thread title to a more fitting one.

Ciao,
Holger

[Curious-George]

Hi thanks for the reply

this is it just copied and pasted

Sub Macro1()
'
' Macro1 Macro
'

'
Cells.Select
Selection.Locked = False
Selection.FormulaHidden = False
Range("A4:A40").Select
Selection.Locked = True
Selection.FormulaHidden = False
Range("K2").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowInsertingColumns:=True, AllowInsertingRows _
:=True, AllowInsertingHyperlinks:=True, AllowDeletingColumns:=True, _
AllowDeletingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True
Columns("H:I").Select
Selection.EntireColumn.Hidden = True
End Sub