Excel Not Responding after running Save and Close Macro Button

Dear All,
Please help for this....

Can't recreate the problem, here - it simply closes the active workbook.

Originally Posted by ExcelGoose

Mangesh, I will need to look at this further however judging from the preliminary stages it looks like this could be due to the code.

Goose

This is all the code is:

Please Login or Register  to view this content.

Nothing there that causes excel to hang... It doesn't even SAVE the workbook, just closes it, so the name is misleading!

I don`t know why but at my end its not responding after pressing button, but when I am saving and closing manually its not showing any error..

Ya.. I have removed the code Save= True... for checking

Originally Posted by ExcelGoose

Hi Olly,

Where in that line of code have you told it to save? You are telling the workbook to close (not even the application).

sub CloseAndSave()

Activeworkbook.saveas Filename:="filepath" & "/" & "Name" & ".xls"
Activeworkbook.close, false

end sub


Goose

We're trying to figure out why the OP is experiencing excel hanging, with his sample workbook. The code he is using is what I posted, and I can't see any thing in his code which may cause Excel to hang or crash.

Hii Olly and Goose I have just checked using normal Form control button with same code instead of Shapes with this its not hanging... So what should I have to do to use Shape instead of Normal Form Control button??...

Its not the code, it is the problem of "Shape" I am using to assign a macro.. I have saved my workbook in Compatibility mode...

Again, I can't see where the problem is. Your attached workbook works exactly as it should - the macro assigned to the shape object fires when clicked, and closes the activeworkbook.

yes i have attached correct workbook