VBA to hide column if not hidden and unhide if hidden

[oblix]

I would like one button to toggle between hiding a column or unhiding column (columns o to p)
The code should first test the status (hidden/unhidden) and then do the opposite
Code must specifically refer to a sheet in workbook and not current or this worksheet
can anybody help

 

[HaHoBe]

Hi,

maybe you can take this code and adapt it to suit:

Sub MrE161210B_HideUnhide()
'https://www.mrexcel.com/board/threads/vba-to-hide-column-if-not-hidden-and-unhide-if-hidden.1219441/
  With Workbooks("Copy_files.xlsx").Worksheets("Sheet1").Columns("O:P")
    .Hidden = Not .Hidden
  End With
End Sub

Ciao,
Holger

 

[oblix]

Thank you for reply.
Will try this solution
How do I unhide between a range and not unhide all?

 

[Peter_SSs]

How do I unhide between a range and not unhide all?

What exactly do you mean by that, noting that you cannot hide (or unhide) part of a column only (unless you hide/unhide entire rows)?