Hide a row and set print area
 

Dear All,
Can we hide a row depending on a cell value.
How to do it programatically on the open even
of the workbook?
afterwards,I also want to define print area depend
to a cell value at the same even.Maybe by using
If statement in VBA code is a good idea.
Thank's for help.