Userform.Hide not working

I have a routine which has a userform. I have a command
that sayss Userform.1.Hide which sometimes does not work
when I run the code. It works if I step through the
code. Why is this?

probaby because of the way you have written your code. Stepping through
the code does not enforce the same behavior. Do you have screenupdating set
to false?

--
Regards,
Tom Ogilvy

"ExcelMonkey" <[email protected]> wrote in message
news:[email protected]...
> I have a routine which has a userform. I have a command
> that sayss Userform.1.Hide which sometimes does not work
> when I run the code. It works if I step through the
> code. Why is this?

Yes my screen updating is set to False. But I thought
this only afffected the spreadsheet. Does having it =
False freeze forms as well?


>-----Original Message-----
>probaby because of the way you have written your code.
Stepping through
>the code does not enforce the same behavior. Do you have
screenupdating set
>to false?
>
>--
>Regards,
>Tom Ogilvy
>
>"ExcelMonkey" <[email protected]> wrote
in message
>news:[email protected]...
>> I have a routine which has a userform. I have a command
>> that sayss Userform.1.Hide which sometimes does not work
>> when I run the code. It works if I step through the
>> code. Why is this?
>
>
>.
>

With the screenupdating set to false and the userform showing, move the
userform around the screen manually. You should see a trail of old images -
so it impedes the update of the screen. I wouldn't exactly say it freezes
the userform although you might want to look at it that way.

--
Regards,
Tom Ogilvy

"ExcelMonkey" <[email protected]> wrote in message
news:[email protected]...
> Yes my screen updating is set to False. But I thought
> this only afffected the spreadsheet. Does having it =
> False freeze forms as well?
>
>
> >-----Original Message-----
> >probaby because of the way you have written your code.
> Stepping through
> >the code does not enforce the same behavior. Do you have
> screenupdating set
> >to false?
> >
> >--
> >Regards,
> >Tom Ogilvy
> >
> >"ExcelMonkey" <[email protected]> wrote
> in message
> >news:[email protected]...
> >> I have a routine which has a userform. I have a command
> >> that sayss Userform.1.Hide which sometimes does not work
> >> when I run the code. It works if I step through the
> >> code. Why is this?
> >
> >
> >.
> >