View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
K11ngy K11ngy is offline
external usenet poster
 
Posts: 31
Default Macro to quit application

Thanks Doug

I tried as below, probably me being stupid but didnt work, is it in wrong
place?

Sub quit()

'
' quit Macro
' Macro recorded 06/07/2007 by stephenking
'

'
activeworkbookclose
End Sub


"Doug Davey" wrote:

Insert ActiveWorkbookClose directly under the last apostrophe, before the
first action recorded - this is what is meant by "after the comments."

HTH
Doug Davey

"K11ngy" wrote:

I was told to create command button and call macro quitapplication, record,
ok and the stop recording, Empty Macro?

The it says edit macro by inserting a line ActiveWorkbookClose after the
comments?

I assume this is in VB but I really dont know where in Vb to enter the
above. Tried everything but no success

Help

Steve