On_Open color coding

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

Phil Hageman

On a network, I have an On_Open sub in Module1 of a
Workbook doing various things. I want to add code in that
sub to set a custom color on the user's color palette.
For example, I want to modify the color of the first
swatch in the fourth row down - from the default hot pink,
to a soft red color. How would I code this?

I have the color modified in the workbook itself; however,
when some network users open the workbook, the hot pink
comes up, rather than the soft red.

These colors are being used in an impedded chart.

Thanks, Phil
 
Hi Phil

Try something like.....

Private Sub Workbook_Open()
ThisWorkbook.Colors(7) = RGB(255, 153, 204)
End Sub
--
XL2002
Regards

William
(e-mail address removed)

| On a network, I have an On_Open sub in Module1 of a
| Workbook doing various things. I want to add code in that
| sub to set a custom color on the user's color palette.
| For example, I want to modify the color of the first
| swatch in the fourth row down - from the default hot pink,
| to a soft red color. How would I code this?
|
| I have the color modified in the workbook itself; however,
| when some network users open the workbook, the hot pink
| comes up, rather than the soft red.
|
| These colors are being used in an impedded chart.
|
| Thanks, Phil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Hyperlinks Without Changing background shading 14
Problem with workbook on_open event 1
Excel 2003 - Color codes 6
Working with colors (default and custom) 4
RGB fill colors 3
Retrieve Excel Colors 2
Check if Excel workbook is open via Word VBA, if open how to close it? 0
Pick a color from the default palette 2

Back
Top