PDA

View Full Version : code to close workbook



ironj32
04-09-2007, 08:32 AM
for some reason i cannot figure out or find the code to close only the active workbook.

application.quit closes all of excel workbooks that are open. i only want to close the the workbook that the userform is in. is there a method for closing the activeworkbook?

mdmackillop
04-09-2007, 08:56 AM
Activeworkbook.Close False or Activeworkbook.Close True depending if you want to save or not.