Thread: Macro
View Single Post
  #2   Report Post  
papou
 
Posts: n/a
Default

Hi
Depending on whether you want to save your workbook before closing it:
Thisworkbook.Close(True)
Or not
Thisworkbook.Close(False)

HTH
Cordially
Pascal

"buzb" a écrit dans le message de news:
...
I am trying to record a macro which will automatically close my workbook
from
an assigned button. When I begin the recording process and then perform
the
action of closing the workbook the macro is also closed and I cannot
complete
the process. When I re-open my workbook the macro has not been created.
Any
suggestions of a way around this would be much appreciated.