Help fixing sheet protection macro to not allow any clicking

[aedctalk]

Hello.

So i have a macro i click that proctects all sheets in workbook.

However when it protects them. It always by default has 2 checkboces marked. (the default ones)

How can i make it so it protects.. but DOES NOT allow clicking of any protected cells

sheet.protect (something go here?)

Thanks so much.! It just getts annoying having to go back and change it constantly!

 

[Smitty]

It's easy enough to record that one:

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
    ActiveSheet.EnableSelection = xlUnlockedCells

HTH,

 

[aedctalk]

thank you smitty. Appreciate it!!!