Macro Problem

[Ed Shanley]

I set up a macro on a shared drive. On the PC I set-it up on, it works just
great. However, whenever someone else opens the file, the macro doesn't
work. I also have an Excel spreadsheet which won't open for anyone else.

Any ideas?

 

[CyberTaz]

Hi Ed;

Would like to help if I can, but need more info.
Mac or PC, What OS version, Which version of Excel?

 

[John McGhie]

Ed:

Please read the Help topic " About templates" and all its children.

Which template did you store the macro in? Can the other user access that
template? What is that user's macro security setting?

Hope this helps

I set up a macro on a shared drive. On the PC I set-it up on, it works just
great. However, whenever someone else opens the file, the macro doesn't
work. I also have an Excel spreadsheet which won't open for anyone else.

Any ideas?

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Consultant Technical Writer
Sydney, Australia +61 4 1209 1410

 

[Ed Shanley]

Howdy Taz,

Okay, I'm an idiot sometimes. I didn't realize this was the "mac" board.
It was done on Windows. I believe the Office version is 2000.

Thanks for your help.

 

[John McGhie]

Hi Ed:

Not a worry, I've done it myself

My questions still apply:

Which template did you store the macro in? Can the other user access that
template? What is that user's macro security setting?

I think your problem is that you have saved the macro in a template that is
not accessible to the other user.

Cheers

Howdy Taz,

Okay, I'm an idiot sometimes. I didn't realize this was the "mac" board.
It was done on Windows. I believe the Office version is 2000.

Thanks for your help.

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Consultant Technical Writer
Sydney, Australia +61 4 1209 1410