Selected Answer
Lynn
This line (or variants of it) would hide the second column in worksheet number 1 of your file ("NJ"):
Worksheets(1).Columns(2).Hidden = True
Paste it into the Intermediate window of VB Explorer and press Enter- column B of NJ will disappear. Overtype True with False, press Enter and it will be restored.
Change the numbers and other columns on other sheets can be hidden or unhidden. The numeric form of the suggested code should make looping through sheets/ columns easier.
You need to do that when a condition is met (e.g. rows 3 to 11 of a given column are all non-zero).
If you have limited experience of VBA, I suggest you look in the VBA section of the Tutorials page, e.g. Loop through All Worksheets in Excel using VBA and Macros and Excel Macro Class 3 - Looping through Ranges & Working with Cells but others too.
Good luck