Hi All

i'm trying to (Excel 2000) loop through userform controls which are set to
enabled = false & locked = true to change them to enabled = true and locked
= false on the On Click of a command button.

I have John Walkenbach's book (excel 2002) where he shows code for looping
through controls but i can't seem to find a way to get to either the enabled
or locked properties - everything i tried resulted in excel crashing !

Help!

Thanks
JulieD

You have a couple of replies at your first post. And one from libby
disconnected from that thread--in my newsreader program at least.)

JulieD wrote:

Hi All

i'm trying to (Excel 2000) loop through userform controls which are set to
enabled = false & locked = true to change them to enabled = true and locked
= false on the On Click of a command button.

I have John Walkenbach's book (excel 2002) where he shows code for looping
through controls but i can't seem to find a way to get to either the enabled
or locked properties - everything i tried resulted in excel crashing !

Help!

Thanks
JulieD

--

Dave Peterson

Hi Dave

i can't see my first post .. however i did see Libby's & Bob's replies as
individual posts - don't quite know what's happened with this.

Thanks
JulieD

"Dave Peterson" wrote in message
...
You have a couple of replies at your first post. And one from libby
disconnected from that thread--in my newsreader program at least.)

JulieD wrote:

Hi All

i'm trying to (Excel 2000) loop through userform controls which are set
to
enabled = false & locked = true to change them to enabled = true and
locked
= false on the On Click of a command button.

I have John Walkenbach's book (excel 2002) where he shows code for
looping
through controls but i can't seem to find a way to get to either the
enabled
or locked properties - everything i tried resulted in excel crashing !

Help!

Thanks
JulieD

--

Dave Peterson