Show user form, leave wosksheet active

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just want to display a warning to users while the sheet is open, but leave the worksheet active. Sounds simple, but I can't find the answer. Any help would be appreciated.
 
Hi Wric,

You have to have at least Excel 2K, and set the ShowModal property of the
userform to false.

Regards, Greg

Wric Smith said:
I just want to display a warning to users while the sheet is open, but
Click to expand...
leave the worksheet active. Sounds simple, but I can't find the answer.
Any help would be appreciated.
 
If you have Excel 2000 or later, show your userform as vbModeless

Userform1.Show vbModeless

--
Regards,
Tom Ogilvy

Wric Smith said:
I just want to display a warning to users while the sheet is open, but
Click to expand...
leave the worksheet active. Sounds simple, but I can't find the answer.
Any help would be appreciated.
 
Thanks. I just wish I knew enough to know what i'm looking for. You guys are Great!

----- Tom Ogilvy wrote: -----

If you have Excel 2000 or later, show your userform as vbModeless

Userform1.Show vbModeless

--
Regards,
Tom Ogilvy

Wric Smith said:
I just want to display a warning to users while the sheet is open, but
Click to expand...
leave the worksheet active. Sounds simple, but I can't find the answer.
Any help would be appreciated.
 
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

Stop users leaving cells blank 8
Run macro before closing Excel 2007 4
Macro to launch the Activate dialog box? 2
closing another file by code causes failure to run workbook activate event 2
Active Workbook from User Form 1
How to activate a User Form 1
Active user form 2
Select Worksheet Where Data is Pasted 1

Back
Top