Hi,
I have two questions:
1. How can I use VBA to easily print a sheet as a PDF-file? I would prefer to have VBA save the file in a certain folder with a certain 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 want the background color of D2 to be rgb(255,0,0) = red. Can that be done "On_Change" of a cell?
I hope you understand how I mean...
Rgds
Lisbeth
aka
Lissu
I have two questions:
1. How can I use VBA to easily print a sheet as a PDF-file? I would prefer to have VBA save the file in a certain folder with a certain 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 want the background color of D2 to be rgb(255,0,0) = red. Can that be done "On_Change" of a cell?
I hope you understand how I mean...
Rgds
Lisbeth
aka
Lissu