Hello you all,
I found this thread which is close, but doesn’t quite answer my concerns: Post 380241
We are on a Novell Network environment, running Windows XP Professional, and Microsoft Excel 2000.
I built the custom functions in a Module, tested them locally, and then did File | Save as | Save as Type: **.xla | sheetinfo.xla.
Then, in a new workbook selected Tools | Add-Ins | Browse to network drive folder, selected “sheetinfo.xla”
Eventually, Excel requires confirmation that I want to copy sheetinfo.xla to a directory on my local C: drive in C:Documents and SettingsusernameApplication DataMicrosoftAddIns
I confirmed, Excel completes the copying, and the user-defined functions worked as expected.
[indent]
‘ Added 22 Feb 2006 by me
‘ Derived from Allen Wyatts Excel Tip
‘ http://exceltips.vitalnews.com/Pages/T0131…sheet_Name.html
Function SheetInfo(numWanted As Byte) As String
Select Case numWanted
Case 1
SheetInfo = Application.Caller.Parent.Name
‘ Returns the worksheet tab name
‘ ActiveSheet.Name old way to get the worksheet name
Case 2
‘ Returns the workbook name
SheetInfo = Application.Caller.Parent.Parent.Name
‘ SheetInfo = ThisWorkbook.Name
Case 3
‘ Returns the workbook full path and name but not worksheet name
SheetInfo = Application.Caller.Parent.Parent.FullName
‘ SheetInfo = ThisWorkbook.FullName
Case Else
SheetInfo = ActiveSheet.Name
End Select
End Function
[/indent]
I distributed this Custom Add-in across the network. Users followed steps above to enable the Add-in on their profile. For Excel workbooks created on their local profile, the user-defined functions worked as expected.
Here’s the trouble encountered. When another networked user (with the Custom Add-in installed in their local profile) attempts to open an Excel workbook on a network drive that I saved, the user gets the following message:
