Try this
![]()
Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Address <> "$S$25" Then Exit Sub Columns(35).EntireColumn.Hidden = Not Columns(35).Hidden End Sub
Try this
![]()
Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Address <> "$S$25" Then Exit Sub Columns(35).EntireColumn.Hidden = Not Columns(35).Hidden End Sub
Last edited by royUK; 02-01-2009 at 07:48 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks