View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default msgbox to NOT display OK Button and to run while saving?

Corey
UserForm2.Show,vbModeless ?

NickHK

"Corey" wrote in message
...
UserForm2.Show
ActiveWorkbook.Save
UserForm2.Hide

Thanks for the reply.

I placed a userform in the code to state the file is saving.
No buttons on it.
But how do i get it to save while it is displayed, it currently only saves
if i click the X.

Corey....