Colors

rcamr · May 25th, 2002, 07:35 AM

Can someone help
How can i change a cell color when a sheet is protected but the cell isnt locked
I need a code please help

Anne Troy · May 25th, 2002, 08:09 AM

I don't understand. If the cell is not protected, you should be able to change the color.

What is happening? Please give more information.

rcamr · May 25th, 2002, 08:13 AM

My macro fails because when a worksheet is protected you cant change cell formats
is there a way

Jack in the UK · May 25th, 2002, 08:23 AM

When I read this post I was sure some posts would be way off the mark, im no VBA guru but I suggest post the code in this SUB and we can have a go,

FIX

You need to un protect, with the password and then make the changes required then re protect this way no one the wiser but you get the result

REMEMBER when VBA runs the sheets dead not one can stop it bare jumping out of cause but to do that is silly you code sounds small and will execute at a snap

HTH

May 25th, 2002, 08:09 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	I don't understand. If the cell is not protected, you should be able to change the color. What is happening? Please give more information. __________________ ~Anne Troy

May 25th, 2002, 08:23 AM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	When I read this post I was sure some posts would be way off the mark, im no VBA guru but I suggest post the code in this SUB and we can have a go, FIX You need to un protect, with the password and then make the changes required then re protect this way no one the wiser but you get the result REMEMBER when VBA runs the sheets dead not one can stop it bare jumping out of cause but to do that is silly you code sounds small and will execute at a snap HTH __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 25th, 2002, 07:35 AM	#1
rcamr New Member Join Date: May 2002 Posts: 21	Can someone help How can i change a cell color when a sheet is protected but the cell isnt locked I need a code please help

May 25th, 2002, 08:13 AM	#3
rcamr New Member Join Date: May 2002 Posts: 21	My macro fails because when a worksheet is protected you cant change cell formats is there a way