Okay, thanks for the tip ... I'll try that.

As a workaround, I found that executing a Save As to the original filename
seems to work within Sharepoint even though the original code works fine from
my PC. So, I'm doing that for now. But I'll look into the corruption issue as
you suggested.

Thanks!

--
JoAnn


"Alan124" wrote:

On Apr 3, 12:32 am, JoAnn wrote:
I have a simple macro that executes the following:

Sub SAVE_Quit()
ActiveWorkbook.Save
Application.Quit
End Sub

I assigned it to a toolbar button called "Save List". Whenever I try to run
the macro from the toolbar, I get the "can't find macro error". But I can
successfully run the macro from the Tools Macro Macros list.

The sheet is protected but I still get the error when I unprotect it.

The macro is stored in Module 1. I tried moving it to This Workbook or Sheet
1 (in case it was stored in the wrong place) but got the same error.

What am I doing wrong?

Thanks!

--
JoAnn

Hi,

I think you should check your excel file first. And if it corrupt, you
can also try a utility called Advanced Excel Repair to repair your
Excel xls file. It works rather well for my corrupt Excel xls files.
Its web address is http://www.datanumen.com/aer/

Hope this helps.

Alan