View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim[_14_] Tim[_14_] is offline
external usenet poster
 
Posts: 7
Default ActiveSheet.Protect UserinterfaceOnly:=true

I need to make changes to a multiple sheet workbook. Some of the
cells are protected. I know the above command in my Subject line will
allow this on a sheet by sheet basis, but I need something else. Is
there a comand line that will allow changes to be made to a worksheet
no matter what sheet is currently activated?

Thanks for the help.