Protection in code?

D

Derrick

hi
i am trying to set up protection settings in code, where it will unprotect
... do the calcs.. then protect

my question involves settings . .. i set up protection settings so that i
can format columns, but when i run my macro, it automatically has its own
settings and i cannot format the columns anymore..
right now, my code looks like

Sheets("Vertical").Unprotect or Protect

what can i write to allow me to format columns?

thanks
 
D

Derrick

nevermind. i found out how to do it - after .Protect write
"AllowFormattingcolumns:=True"
 

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

Top