I don't know of any issues with this.

I save lots of workbooks with macros to network drives and the macros work fine
(or as well as I wrote them!).

You are enabling macros when you open the workbook?

(I'm assuming yes to that.)

How do you invoke the macros--buttons on toolbars, commandbuttons placed on the
worksheet from the control toolbox toolbar, buttons from the Forms toolbar
placed on a worksheet, tools|macro|macros and selecting?

And what does fail really mean? (That should have been my first question!)

Steve Simons wrote:

Hi

I have a macro in a spreadsheet that works fine if the file is saved locally. If I move it to a networj drive it fails.

Are there any known issues with doing this?

TIA

Steve

--

Dave Peterson