VBA Protected sheet allow Select Visible Cells

[Grimm127]

Hello all you Gurus out there.

I need a little help.

So in "ThisWorkbook" I have these lines of code

sht.EnbleOutlining = true
sht.protect Allowfiltering:=True


What code can I put in here that I am able to "Select Visible Cells Only"?

I need this to be able to paste in data to only those cells which the file is protected. Is there anything for this?
Thanks!

 

[Smitty]

So you're trying to paste data into locked cells on a protected sheet?

Just unprotect the sheet, paste, then reprotect.

ActiveSheet.Unprotect
Copy/Paste
ActiveSheet.Protect

HTH

 

[Grimm127]

So you're trying to paste data into locked cells on a protected sheet?

Just unprotect the sheet, paste, then reprotect.

ActiveSheet.Unprotect
Copy/Paste
ActiveSheet.Protect

HTH

No, I nee it locked because its part of my validation.