Auto hide columns

[xaritona89]

Hello,
I have an excel file. I want to automatically hide the corresponding columns during opening.
How can this be done?

P.S. With the help of Python, I automatically open Excel and take a picture. When opening, I want it to be hidden if cell = 0, or visible if cell = 1.

 

[xaritona89]

Try to save as .xlsm

I save file xlsm, but your code not work.

 

[bebo021999]

I save file xlsm, but your code not work.

Try to test by click on other sheet, then activate this sheet again.

 

[Alex Blakenburg]

When you test @hrayani's code it goes in "ThisWorkbook" per the below - it is a Workbook event.
bebo's code goes in Sheet1 where you had hrayani's code - it is a WorkSheet event.

 

[xaritona89]

I solved:
1. create Button, used hrayani code.
2. used python and activated it.

I wanted to open excel(automatical update) and take picture.