View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rockee052[_51_] Rockee052[_51_] is offline
external usenet poster
 
Posts: 1
Default Close WorkBook with CommandButton

Ron,

Thanks for your reply. I found a soulution before reading you reply.

Private Sub CommandButton3_Click()
Application.ScreenUpdating = False
With ActiveWorkbook
.RunAutoMacros xlAutoClose
.Close
End With
Application.ScreenUpdating = True
End Sub

So far so good, it also calls the custom save dialog box. I'm going t
play around with it and see what errors I can cause :) .

Thanks

Rocke

--
Message posted from http://www.ExcelForum.com