Help with run-time error, please...

  • Thread starter Thread starter Mick
  • Start date Start date
M

Mick

Can any advise how I can overcome this Run-time error when using the code
below:

Unprotect method of worksheet class failed

Worksheets("Template").Protect Password:="MyPassword"
 
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

How do I unprotect a sheet within a macro? 4
Sorting a protected worksheet 1
Macros and Password Protection 6
Password protection worksheet 1
Runtime error 57121 5
Unprotect Workbook with Function 3
Excel Protection 2
Sheet protection 1

Back
Top