change color
 

i have merged cell in this rang, when sheet is protecetd (cells B2:J4 are
obviously not) the following does not work
Any ideas

Range("B2:J4").Interior.ColorIndex = 36

change color
 

Hi
It won't change the interior even if it is not merged. I don't know
why - bug maybe?
You could remove the password, change the interior then put back the
password

With ActiveWorkbook
. Unprotect Password:="myPassword"
.Range("B2:J4").Interior.ColorIndex = 36
.Protect
end with

regards
Paul

On Apr 30, 1:45*pm, "sunilpatel" wrote:
i have merged cell in this rang, when sheet is protecetd (cells B2:J4 are
obviously not) the following does not work
Any ideas

Range("B2:J4").Interior.ColorIndex = 36