View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
MIguel MIguel is offline
external usenet poster
 
Posts: 33
Default Make a check box run a macro


Thanks a lot. It works

"Miguel" wrote:

In addition to that,
how can I add this macro to this checkbox?

Thanks

"Miguel" wrote:

Hello,
I want a check box run a macro. Basically what I want to do is if the check
box is cheked then some columns become unhide. If the checkbox is not checked
then the columns remain hide. The check box is on the "Main Input" and the
columns hidden or not are on the "Summary" worksheet. This is what I wrote so
far:

Sheets("Summary").Select
Columns("AS:BA").Select
Selection.EntireColumn.Hidden = False
Range("A1").Select
Sheets("Main Input").Select
End Sub

Thanks
Miguel