I have been through the search on numerious occasions and can't find an answer. Here is my problem.

I have a sheet for my work load. I want to hide rows that have a blank cell in colum B when a key is pressed. However, I want the rows to unhide when the workbook is opened.

Any help would be greatly appreciated.

Thanks,
Danno