Hide columns on sheet2 based on cell on sheet1?

This is what I would like to do if possible:

If E9 on Sheet1 is 1, then hide columns F-L on Sheet2.

Thanks for helping me.

Excel 2000

Hi proepert
In the worksheet1 module

Please Login or Register  to view this content.

try this code

Please Login or Register  to view this content.

One line

Please Login or Register  to view this content.

proepert

Thanks for the rep.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save