Re: $$Excel-Macros$$ Column hide from excel

Thank you On Fri, Oct 8, 2010 at 6:07 PM, عمر wrote: > 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

Re: $$Excel-Macros$$ Column hide from excel

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

RE: $$Excel-Macros$$ Column hide from excel

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(

Re: $$Excel-Macros$$ Column hide from excel

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