View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dick Minter[_2_] Dick Minter[_2_] is offline
external usenet poster
 
Posts: 6
Default clearing unlocked fields on a protected sheet

I know that my cmd button code can unlock a worksheet, then step through a
list of named ranges to clear, but is there a better way, say using "For
each...next" to step trhough each cell in a named range to test for the
"unlocked" cells, then clearing? Can you address each cell as a range in a
collection of ranges using For...each?

DM