How to unprotect target xls-sheet in VBA using advanced filter?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have a spreadsheet with advanced filter, that copies the result to another
sheet. Won't work with sheet-protection enabled. Anyone knows how to
unprotect the target sheet prior to the automated copying, and then
protecting the sheet again, to avoid user-error...?

other suggestions?
 
Maybe,

Sub protectmenot()
Worksheets("Sheet3").Unprotect Password:="mypass"
'do you stuff
Worksheets("Sheet3").Protect Password:="mypass"
End Sub

Mike
 
Perfect! Thank a lot!

BR Kjetil

Mike H said:
Maybe,

Sub protectmenot()
Worksheets("Sheet3").Unprotect Password:="mypass"
'do you stuff
Worksheets("Sheet3").Protect Password:="mypass"
End Sub

Mike
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL to unprotect and protect worksheet 7
protect sheet using vba 1
Copying in sheet with protection with the use of a macro 5
Xl2007 not unprotecting worksheet!!!! 1
Macro to Un Hide filtered rows 3
Macro can not unprotect a sheet in a shared workbook 4
autofilter on a protected sheet 6
Protecting sheet in a macro doesn't work 1

Back
Top