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.