Hi
I have a macro that colors selsected cells. I have copied and pasted the
macro into an existing workbook. However when I run the macro, the colors
that I have assigned do not come out the same as in the original workbook.
The macro calls for color 40 which is a tan color. But when it runs in the
other book it comes out a gray If I go to manully shade the cell the drop
down pallette has that tan gray color where the tan was in the original
workbook.
Any ideas?

hi,
I think someone has messed around with the colors on the
second machine. that is the only thing i can think of.
excel does give you a way to modify the available 56
colors.
go to tooloptionscolor tab and click the reset button.

-----Original Message-----
Hi
I have a macro that colors selsected cells. I have
copied and pasted the
macro into an existing workbook. However when I run the
macro, the colors
that I have assigned do not come out the same as in the
original workbook.
The macro calls for color 40 which is a tan color. But
when it runs in the
other book it comes out a gray If I go to manully shade
the cell the drop
down pallette has that tan gray color where the tan was
in the original
workbook.
Any ideas?

.

Great! Thanks

" wrote:

hi,
I think someone has messed around with the colors on the
second machine. that is the only thing i can think of.
excel does give you a way to modify the available 56
colors.
go to tooloptionscolor tab and click the reset button.

-----Original Message-----
Hi
I have a macro that colors selsected cells. I have
copied and pasted the
macro into an existing workbook. However when I run the
macro, the colors
that I have assigned do not come out the same as in the
original workbook.
The macro calls for color 40 which is a tan color. But
when it runs in the
other book it comes out a gray If I go to manully shade
the cell the drop
down pallette has that tan gray color where the tan was
in the original
workbook.
Any ideas?

.