pls send the original sheet
2009/6/15 zheng yu <vincent2...@gmail.com>
> hmm..anybody can make the macro work in the original sheet?
>
>
> On Fri, Jun 12, 2009 at 6:29 PM, zheng yu <vincent2...@gmail.com> 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 sheet and take a look..
>>
>>
>>
>>
>> On Fri, Jun 12, 2009 at 3:13 PM, Fabio Lemos <flnle...@gmail.com> wrote:
>>
>>> I have tested and it works for me....
>>> Have you turnedmacros on?
>>>
>>>
>>>
>>> 2009/6/12 zheng yu <vincent2...@gmail.com>
>>>
>>>> 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 functions and
>>>> it works..but I can't fix this one. Please take a look.
>>>>
>>>> in sheet" Parametervalg" there is a simple Worksheet_change event, and
>>>> I just put these lines of code there. And amazingly they don't work.
>>>>
>>>> The problem is that in Range("C5"), there is 5 numbers you can choose
>>>> 0,1,2,3,4,5. And when you choose 0, it will hide certain columns; when you
>>>> choose 1 it will unhide them. Rest of numbers do similar things. But when I
>>>> choose 0, it doesn hide all columns, and when i choose 1, it DOES NOT
>>>> unhide
>>>> all of them.... when I write this piece of code in a new sheet,it works
>>>> just
>>>> fine.....
>>>>
>>>> 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
>>>>
>>>>
>>>> By the way, anyone here in the forum does Excel-addin C++ development ?
>>>>
>>>> Vincent
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Fabio Lemos
>>>
>>> e-mail: flnle...@gmail.com
>>>
>>>
>>>
>>
>
> >
>
--
Fabio Lemos
e-mail: flnle...@gmail.com
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
