MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Editing a Macro


Posted by Bill Kelly on February 28, 2001 9:30 AM

For some reason Excel isn't allowing me to eidt a macro that is in a spreadsheet. I am sure that this is a simple fix but for the life of me I can't figure out what it is. Please help.

Thanks


Posted by David Hawley on February 28, 2001 1:23 PM


Hi Bill

Can you tell me what happens when you try ?

OzGrid Business Applications

Posted by Bill Kelly on February 28, 2001 2:09 PM

It says "Project is unviewable." I think the problem is that it is a shared file though and since more than one person is in it, it won't let me change the macro. Does that sound like a root problem?

Thanks

Posted by David Hawley on February 28, 2001 3:47 PM


Bill, yes it sounds quite feasable. Are you trying access them via Tools>Macro>Macros>Edit ? If so try pushing Alt+F11 and accessing it that way.


Dave
OzGrid Business Applications

Posted by William Kelly on February 28, 2001 8:26 PM

Dave,

I tried using the short cut a couple times as well, but I get the same error. Thanks for the help though, I will just either wait for a time nobody is using the file or kick everybody out through the Tools>Share Workbook menu.

Thanks again.

Billy