close

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 quot;fullquot; 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
quot;On_Changequot; of a cell?

I hope you understand how I mean...

Rgds
Lisbeth
aka
Lissu--
Lissu
------------------------------------------------------------------------
Lissu's Profile: www.excelforum.com/member.php...oamp;userid=34431
View this thread: www.excelforum.com/showthread...hreadid=541965

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄