worksheet before_print event...
Posted by Jojo on January 04, 2002 5:33 AM
is this possible..i like to make thing possible..
hope you guys can help me..
let say i use sheet1..before user can print anything ..
a macro will run ( worksheet before_print event.)
and write to all the cells that are used..(print something
like "trial" to all cells...after that input box
will prompt the user to keyin the right password..if the
password is correct..another macro will run
and delete all the "trial " words in all the cell..if the
passwword is wrong . "trial" words will remain and the sheet
will be print with "trial" all over the sheet..thanks and
hope someone will help me in achieved this..happy new
year to all excel experts here..regards