VBA code?

  • Thread starter Thread starter Dave Jones
  • Start date Start date
D

Dave Jones

I apologize for the newbie question. I have been given some VBA code to
sort data in a spreadsheet. I don't need this code right now but will at
some point in the future. Can this code be stored in a template for
later use when that template is called? I need to have a "library" for
future code that I'm having developed that can be easily accessed when I
need it.
Dave
DDP
 
You could create a new workbook and put the code in that workbook.

You could create a text file and just save it there.

Whichever you use, give it a memorable name so you can find it when you need it.
 
Just save it in a workbook and save the workbook off somewhere, either as a
template xlt file or a standard xls workbook.
 
Dave

I save all the extra macros I might need to a new workbook then save that as
an Add-in.

Available under Tools>Add-ins.


Gord Dibben MS Excel MVP
 
I keep the macros that I want available in an addin that I load each time excel
loads. But I lots and lots more macros that are just stored in a text file.

Some are things I've posted and some are things I've read on the newsgroup.
 
thanks to all, I'll create a workbook that I'll save the macros in for
later use.
Dave
DDP
 
Back
Top