Show user form, leave wosksheet active
 

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.

Show user form, leave wosksheet active
 

Hi Wric,

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

Regards, Greg

"Wric Smith" wrote in message
...
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.

Show user form, leave wosksheet active
 

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

Userform1.Show vbModeless

--
Regards,
Tom Ogilvy

"Wric Smith" wrote in message
...
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.

Show user form, leave wosksheet active
 

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" wrote in message
...
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.