View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lissu
 
Posts: n/a
Default Cell color and PDF


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


--
Lissu
------------------------------------------------------------------------
Lissu's Profile: http://www.excelforum.com/member.php...o&userid=34431
View this thread: http://www.excelforum.com/showthread...hreadid=541965