"Chiku" wrote in message
...
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


Add the code in workbook_open

Private Sub Workbook_Open()
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code

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

How would they enter data in B if it is hidden? any cell?