Protecting excel worksheet 1

[pruleone]

Hi,

I would like use VBA code to protect excel worksheet and same time give users option to format cells, columns, rows.

I have recorded two different VBA codes but don't know how to merge them. Maybe someone can help?

First code:
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True

Second code:
ActiveSheet.Protect Password:="1

 

[PHV]

ActiveSheet.Protect Password:="1", DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[pruleone]

Thank you,

I tried so, but seams that I made something wrong.

 

[SkipVought]

Turn on you macro recorder and record doing exactly what you need to happen.

Then observe your recorded code.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[judgeh59]

Hi Skip

I don't know if this is appropriate but I'm going to jump in with both feet. I have used this site for a long time and mostly just observing and getting info. I just wanted to say that using the macro recorder is the best advice I have gotten from you (although indirectly). I have a postnote on my monitor "did you try the macro recorder?". Anyways thanks again.

Be Alert, America needs more lerts

 

[pruleone]

Macro recorder is nice thing but it didn't somehow record all I entered that's why I had question

 

[SkipVought]

...but it didn't somehow record all I entered ...

That would have been pertinent to declare.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]