Missing custom list?

  • Thread starter Thread starter kildevil
  • Start date Start date
K

kildevil

I created a custom list to use for sorting data and use it while runnin
a macro. It works fine on my workstation, but if I share the workboo
with others the custom list is not there. If I open the workbook an
recreate the list manually on the other workstation, the macro run
fine. I had assumed that the custom list would be married to th
workbook, not the workstation.

Is there a means to correct this
 
Start the macro with a VBA creation of the custom list. Something like...

Application.AddCustomList ListArray:=Array("Sunday1", _
"Monday1", "Tuesday1", "Wednesday1", _
"Thursday1", "Friday1", "Saturday1")

This way you don't have to worry about any workstation ever not having your
custom list.

HTH,
Gary Brown
 
Back
Top