View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Wric Smith Wric Smith is offline
external usenet poster
 
Posts: 2
Default 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.