UserForms and workbook manipulation

  • Thread starter Thread starter Mike Mertes
  • Start date Start date
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
 
You can only do it if you are displaying the UserForm modelessly (Excel 2000
and later):

UserForm1.Show vbModeless
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

closing another file by code causes failure to run workbook activate event 2
Call UserForm procedures from another workbook 2
how to reshow userform after following a link 1
Hide Userform when viewing a different workbook 3
Activate Workbook via UserForm/Listbox ??? 3
UserForm as Reader 3
Active Workbook from User Form 1
Save workbook button on Userform 2

Back
Top