Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection in code?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection in code?
nevermind. i found out how to do it - after .Protect write
"AllowFormattingcolumns:=True" "Derrick" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code Protection | Excel Programming | |||
password protection via code | Excel Programming | |||
vba code protection | Excel Programming | |||
Sheet Protection and XLA code | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |