sharing macros

W

Whitney

What path do you enter under Tools>Options>General?

I saved the file to a shared network drive. So I entered N:\SHARED.XLS ,
closed
excel and reopened it, but the macro was not visible.
Drive name is customer service$ on nppdfwi1
 
J

jlclyde

What path do you enter under Tools>Options>General?

I saved the file to a shared network drive. So I entered N:\SHARED.XLS ,
closed
excel and reopened it, but the macro was not visible.
Drive name is customer service$ on nppdfwi1










- Show quoted text -
Click to expand...

You may have saved your macro into your personel macro workbook and
not into the file that you intended. If you click Alt + F11 this will
bring up VB. Move the module from your personel Macro workbook into
the file that you intended to put it.
Jay
 
W

Whitney

It's definitely there. On my computer I show the two macros (personal and
shared)
when I open the shared file.
PERSONAL.XLS!AvailAgentFormatting
SHARED.XLS!AvailAgentFormatting

What I'm trying to do is set it up to auto open the shared file on someone
else's computer by following the below steps however, I'm not sure what path
to type in the At startup, open all files in: field.
 
H

Harald Staff

Sub test()
MsgBox "Put it in " & Application.StartupPath, , _
"HTH. Best wishes Harald"
End Sub
 
Top