change color

's Computer Specifications

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

's Computer Specifications

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" <sunilpa...@talktalk.net> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
in EQUATION EDITION (WORD) change color(color of numbers and symbo	=?Utf-8?B?ZnJhbmNpcyBpcyB0aGFua3MgdG8geW91IC4gLiAu	Microsoft Word Document Management	1	29th Nov 2006 03:45 PM
change auto underline color for red/green color blindness	=?Utf-8?B?T25zYmVyZw==?=	Microsoft Word Document Management	1	23rd Sep 2006 04:17 PM
change fill color of a range of cells based on color of a cell?	=?Utf-8?B?RGFyTWVsTmVs?=	Microsoft Excel Programming	0	2nd Mar 2006 06:35 PM
Bullet Font Color Changes When I Change Text Color--Can I Change it Back?	J. Danniel	Microsoft Powerpoint	2	17th Mar 2005 08:06 PM
Browse Forms Controls and change TextBox color based on cell color	=?Utf-8?B?U3RlZmFuVw==?=	Microsoft Excel Programming	0	21st Nov 2004 04:28 AM