Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform.Hide not working
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" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform.Hide not working
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" wrote in message ... 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? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform.Hide not working
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" wrote in message ... 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" wrote in message ... 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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Userform | Excel Programming | |||
Hide Tab in TabSheet on UserForm | Excel Programming | |||
Hide all images on userform | Excel Programming | |||
Userform.hide / show | Excel Programming | |||
hide a textbox on a userform? | Excel Programming |