The key is "and enabled sharing so that others wouldn't be able to change the
macros within it." Remove the sharing, and you will be able to change the
macros. Once you are satisfied, share it again.

" wrote:

Hello group:

I have a question regarding a shared Excel file with a project that I
am past a deadline on. Some time ago I
created an Excel file and enabled sharing so that others wouldn't be
able to change the macros within it. I have now run into the problem
of having to change something within a macro....how do you make it so
that you can do this? This file I originally created on
my computer before I formatted it, so I don't know if that makes any
difference as far as for identification purposes (since I had a
different computer name and user name). The file was created with
Win 2000, Excel 2002.

Thanks very much in advanced for your response.