View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Newbie1 Newbie1 is offline
external usenet poster
 
Posts: 6
Default Button to close without saving

Hello

I am trying to create code for a commandbutton on a userform which will
close the workbook without saving.

Using <Application.quit throws up a message box giving the user a choice
(which I do not want!)

Is there something similar to <ThisWorkbook.Save (but obviously does not
save!)

Thanks

Kenny