I have a macro that hides blank rows whenever there is no value in a
particular cell. Two things:
1.) How do I program the macro to run everytime the file is opened

2.) How do I also program the macro to run every time someone adds a value
in any of the cells that determine whether its row should be hidden? In other
words, column B contains the cells in which when blank, the row is hidden.
Now I want to unhide the row if someone enters data in the cell in column B

(Let me know if I need to explain some more)