vba - How to enable Cell re-size on protected Excel Sheet -

i have macro disable row based on value of others row , witch working fine

 private sub worksheet_change(byval target range)     call securitycolumnslookup(target) end sub private sub workbook_open(byval target range)     call securitycolumnslookup(target) end sub private sub securitycolumnslookup(byval target range) on error goto myerr     err.clear     activesheet.unprotect      application.enableevents = false  select case range("v" & (target.row)).value    //do stuff       end select  activesheet.protect     application.enableevents = true     exit sub myerr:     on error resume next  activesheet.protect     application.enableevents = true     exit sub end sub  private sub worksheet_selectionchange(byval target range)         call securitycolumnslookup(target)     end sub 

what know how add code macro in order allow user re-size rows , because happening right , when macro active , mouse mouse on cell re-size icon doesn't appear

is possible enable re-sizet feature @ time?

thank you

i found solution problem , explained in link

http://www.thespreadsheetguru.com/the-code-vault/2014/2/21/protect-worksheet-but-allow-formatting-and-hiding-rows-columns

adding

    activesheet.protect , allowformattingcolumns:=true, allowformattingrows:=true application.enableevents = true 

will let macro enable resize option !