I've got a spreadsheet with multiple workbooks, and if I set a cell
worksheet1 to be purple, I need a corresponding cell on worksheet6 to
also turn purple, and vice versa. Is there any way to automate this?
Manual colorchanging across multiple worksheets is tedious,
timeconsuming, and has lead to inconsistencies before. I'd love to
eliminate any "human error", if at all possible. Thanks!

coloring a cell doesn't fire any events, so you would need to use the
workbook level selectionchange to do your updating.

See Chip Pearson's page on events for an overview -
http://www.cpearson.com/excel/events.htm

then just use the selection change to record your rules in code.

--
Regards,
Tom Ogilvy


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I've got a spreadsheet with multiple workbooks, and if I set a cell
> worksheet1 to be purple, I need a corresponding cell on worksheet6 to
> also turn purple, and vice versa. Is there any way to automate this?
> Manual colorchanging across multiple worksheets is tedious,
> timeconsuming, and has lead to inconsistencies before. I'd love to
> eliminate any "human error", if at all possible. Thanks!
>

Thanks for the super-quick response! Unfortunately, I'm an Excel
semi-novice (okay, uber-novice), and have no experience with VBA
coding, so that link went directly over my head. Is there something
else I could reference to help get a better grasp on this, or even see
some sample code to stare at?

Tom Ogilvy wrote:
> coloring a cell doesn't fire any events, so you would need to use the
> workbook level selectionchange to do your updating.
>
> See Chip Pearson's page on events for an overview -
> http://www.cpearson.com/excel/events.htm
>
> then just use the selection change to record your rules in code.
>
> --
> Regards,
> Tom Ogilvy
>
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I've got a spreadsheet with multiple workbooks, and if I set a cell
> > worksheet1 to be purple, I need a corresponding cell on worksheet6 to
> > also turn purple, and vice versa. Is there any way to automate this?
> > Manual colorchanging across multiple worksheets is tedious,
> > timeconsuming, and has lead to inconsistencies before. I'd love to
> > eliminate any "human error", if at all possible. Thanks!
> >

http://www.mvps.org/dmcritchie/excel....htm#tutorials

Links to tutorials. The VBA tutorials are after the general excel
tutorials.

--
Regards,
Tom Ogilvy

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks for the super-quick response! Unfortunately, I'm an Excel
> semi-novice (okay, uber-novice), and have no experience with VBA
> coding, so that link went directly over my head. Is there something
> else I could reference to help get a better grasp on this, or even see
> some sample code to stare at?
>
> Tom Ogilvy wrote:
>> coloring a cell doesn't fire any events, so you would need to use the
>> workbook level selectionchange to do your updating.
>>
>> See Chip Pearson's page on events for an overview -
>> http://www.cpearson.com/excel/events.htm
>>
>> then just use the selection change to record your rules in code.
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > I've got a spreadsheet with multiple workbooks, and if I set a cell
>> > worksheet1 to be purple, I need a corresponding cell on worksheet6 to
>> > also turn purple, and vice versa. Is there any way to automate this?
>> > Manual colorchanging across multiple worksheets is tedious,
>> > timeconsuming, and has lead to inconsistencies before. I'd love to
>> > eliminate any "human error", if at all possible. Thanks!
>> >
>