macro won't run from network

[Steve Simons]

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]

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!)

 

[CLR]

Try saving the file to a different directory on your local drive, or a
different drive on your local machine.........and if the macros still fail,
then chances are that they are written so as to be specific to the original
path or filename........

Vaya con Dios,
Chuck, CABGx3

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.