View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill James[_2_] Bill James[_2_] is offline
external usenet poster
 
Posts: 13
Default Save lookup data in template (.xlt)

Is it possible to store lookup data in a .xlt template file and access the
sheet from with the VBA code stored in the .xlt file itself?

I created a .xlt template with one worksheet and a toolbar with one button.
This template contains data along with some macros that reference that data.
Unfortunately, the macro ends with an error when run from a workbook without
the referenced worksheet. Is it possible to reference the worksheet
contained within the .xlt template?