View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billy Liddel Billy Liddel is offline
external usenet poster
 
Posts: 527
Default Macros for checkboxes

Min

another way to hide an individual column.

Creat a list of the cols to hide, say on a new sheet. I used COls E to H

On the sheet you want to operate add a combo box, I linked it to A1. then I
assigned this macro.

Sub HideCol()
c = Range("A1") + 3
Columns(c).EntireColumn.Hidden = Not Columns(c).EntireColumn.Hidden
End Sub

Maybe this will help another time

Peter