Thread: Syntax for a macro to unprotect a union of cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy[_7_] Doug Glancy[_7_] is offline
external usenet poster
  
Posts: 55
Default Syntax for a macro to unprotect a union of cells
Roy,

allcells.Locked = False

hth,

Doug

"Roy Peck" wrote in message
...
Have a union of a hundred cells similar to the line of code below.
set cell???? = range("??")
Set allcell = Application.Union(cell1720, cell1721, cell1722)
allcells.Value = ""
allcells.Font.ColorIndex = 0

What is the syntax to unprotect all cells in "allcell"
--
roypeck


Reply With QuoteReply With Quote