UserForms and workbook manipulation
 

Mornin',

When I load and show a userform, I can't select or activate cells on the
workbook behind it. I tried hiding the form from view, but that's not the
solution. I also tried enabling screen updating, but that didn't work
either.

If anyone can suggest how I might be able to activate cells while a user
form is open, I'd appreciate it!

Many thanks,
Mike

UserForms and workbook manipulation
 

You can only do it if you are displaying the UserForm modelessly (Excel 2000
and later):

UserForm1.Show vbModeless

--

Vasant



"Mike Mertes" wrote in message
...
Mornin',

When I load and show a userform, I can't select or activate cells on the
workbook behind it. I tried hiding the form from view, but that's not the
solution. I also tried enabling screen updating, but that didn't work
either.

If anyone can suggest how I might be able to activate cells while a user
form is open, I'd appreciate it!

Many thanks,
Mike

UserForms and workbook manipulation
 

Thanks so much, you refreshed my memory. :-)

-Mike

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
You can only do it if you are displaying the UserForm modelessly (Excel
2000
and later):

UserForm1.Show vbModeless

--

Vasant



"Mike Mertes" wrote in message
...
Mornin',

When I load and show a userform, I can't select or activate cells on the
workbook behind it. I tried hiding the form from view, but that's not
the
solution. I also tried enabling screen updating, but that didn't work
either.

If anyone can suggest how I might be able to activate cells while a user
form is open, I'd appreciate it!

Many thanks,
Mike