Cell color and PDF

L

Lissu

Hi,

I have two questions:

1. How can I use VBA to easily print a sheet as a PDF-file? I woul
prefer to have VBA save the file in a certain folder with a certai
name - created by VBA. (I have the "full" Acrobat...)

2. In A2 I have the value 255, in B2 it's 0 and C2 also 0. Now I wan
the background color of D2 to be rgb(255,0,0) = red. Can that be don
"On_Change" of a cell?

I hope you understand how I mean...

Rgds
Lisbeth
aka
Liss
 
Top