Edit Personal.xls via Macro

[Bob Phillips]

The simplest way is to update your personal.xls, export the file, and have a workbook that has an auto-open macro or workbook_open event code that imports that file into the hot's personal .xls.

If you tell them to load both the module file and your update file into the same directory, this code, which goes in ThisWorkbook code module, will import it

[vba]

Private Sub Workbook_Open()
Dim ModuleFile As String

ModuleFile = ThisWorkbook.Path & "\ModuleName.bas" '<<<< change filename to suit
Workbooks("Personal.xls").VBProject.VBComponents.Import (ModuleFile)
End Sub
[/vba]