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.

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.

Fantastic! I've spent all day trying to figure this one out and you've
probably saved me many more days. Thanks.

"buzb" wrote:

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.