Hide a row and set print area

S

shiro

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
Upgraded from Win 7 to Win 10. Publisher printing black. 1
Conditional formatting 2
Hiding rows and printing 1
Printing problems with hidden rows 1
How do I have a cell value define a dynamic named range? 15
Creating a function to auto hide rows 1
Hide Row Numbers/Column Letter in VBA 1

Top