Code cancels protection properties

  • Thread starter Thread starter gavmer
  • Start date Start date
G

gavmer

Hi all,

Have a small prob. I run a code that unprotects then protects a shee
after running a copy/paste procedure. Prob is, after the code runs,
am no longer able to delete rows. Before the code ran i set th
protection to allow deletion of rows but running the code seems t
cancel this.

Is there a way round this??

Cheers all!
 
gavmer


After you run your code does it reset the password to protect th
sheet? If so you can not delete rows

Charle
 
Hi charles,

Yes, it uses the password to unprotect and then uses the password t
protect the sheet once again. How can i get around this??

Cheers!
 
Hi,

When you re-protect the sheet are you using

ActiveSheet.Protect UserInterFaceOnly := True

regards,
Don
 
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

Excel Protection 2
Spell Checking on a protected sheet 1
VBA code to protect cells Outside a given range 2
Excel VBA-Protect and unprotect sheet with BVA 1
Shapes and protection xl2000/2003 5
Worksheet protection prevents Data Validation code from running... 1
Controlling worksheet protection via VBA 0
Copying in sheet with protection with the use of a macro 5

Back
Top