UserForms and workbook manipulation

M

Mike Mertes

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
 
V

Vasant Nanavati

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

UserForm1.Show vbModeless
 
Top