change color

[sunilpatel]

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

 

[paul.robinson]

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