Thread: Closing Excel with Visual Basic
View Single Post
  #5 (permalink)  
Old 12-08-03, 08:22
John Allen John Allen is offline
Registered User
  
Join Date: Dec 2003
Location: Wellingborough , UK
Posts: 3
Unhappy Re: Closing Excel with Visual Basic
Quote:
Originally posted by RickKnight
Use a macro:

Sub CloseIt()

' Keyboard Shortcut: Ctrl+q
'
ActiveWorkbook****nAutoMacros Which:=xlAutoClose
End Sub
I tried this but nothing seemed to happen...probably something I'm not doing.
Reply With Quote