pls send the original sheet
2009/6/15 zheng yu
> hmm..anybody can make the macro work in the original sheet?
>
>
> On Fri, Jun 12, 2009 at 6:29 PM, zheng yu wrote:
>
>> Hey guys thanks
>>
>> but ..I copy the code into new sheet, and it works perfect too.. it is
>> just in that original sheet, i
hmm..anybody can make the macro work in the original sheet?
On Fri, Jun 12, 2009 at 6:29 PM, zheng yu wrote:
> Hey guys thanks
>
> but ..I copy the code into new sheet, and it works perfect too.. it is just
> in that original sheet, it only works for 0 ,but rest of them..
>
> please open the she
Hey guys thanks
but ..I copy the code into new sheet, and it works perfect too.. it is just
in that original sheet, it only works for 0 ,but rest of them..
please open the sheet and take a look..
On Fri, Jun 12, 2009 at 3:13 PM, Fabio Lemos wrote:
> I have tested and it works for me
> H
Hi Vincent,
I tried your macro code in your workbook and it did hide/unhide
columns G:K for me. Perhaps there's an extra step required for me to
replicate the problem? (I'm using Excel 2007 btw)
If you place a breakpoint in your Worksheet_Change code, does the
compiler reach it? This would conf
Try this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value = 0 Then
MsgBox "000"
'Sheets("Parametervalg").Select
Columns("G:K").EntireColumn.Hidden = True
End If
If Target.Value = 1 Then
MsgBox "111"
Columns("G:K").EntireColumn.Hidden = False
End If
End Sub
I have tested and it works for me
Have you turnedmacros on?
2009/6/12 zheng yu
> Hi All,
>
>I got this request from a colleague who is asking me to find out the
> problem assuming i am the best VBA and C++ programmer here.;P
>
>But I can't fix it. I can create a new sheet with same
