Macro

B

buzb

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.
 
P

papou

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

HTH
Cordially
Pascal
 
B

buzb

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