r 08, 2010 12:34 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Column hide from excel
>
>
>
>
>
> 4 column(A,B,C,D) in atteched excel, please tell me how to do this
> --
> With Regards,
> *Vishal K. Angre*
>
Dear Sumit
only 4 column(A,B,C,D) in atteched excel how to hide column E,F,H.
thank & regard
Vishal
On Fri, Oct 8, 2010 at 5:08 PM, SUMIT VYAS wrote:
> Dear Vishal
>
> This trick is VBA inst log file.
>
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Cells.Count = 1
See this
http://www.youtube.com/watch?v=CrX6353lSx4
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Vishal Angre
Sent: Friday, October 08, 2010 12:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Column hide from excel
4 column
Dear Vishal
This trick is VBA inst log file.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count = 1 Then
If Target.Value <> "" Then
If Target.Column = 3 And Target.Row > 1 Then
Target(1, -1) = Format(Now, "dd-mmm- hh:mm:ss")
Target(1, 0) = Application.UserName
End If
E
4 column(A,B,C,D) in atteched excel, please tell me how to do this
--
With Regards,
*Vishal K. Angre*
E-mail : visha...@gmail.com
vishal.k.an...@gmail.com
--
--
Some important links for excel users:
1.