Kiran has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
VBA code as a template
Is it possible to create a code and save it as a template to be called into any other spreadsheet (with the core essential fixes fields, ofcourse, that will apply to all or most of spreadsheets). if so, how to do it?
Regards
Kiran
RE: VBA code as a template
Hi Kieran
Thanks for your question
I am assuming you want the code to be available to any workbook you open. The best solution would be to write your code in the personal macro workbook, which you can access through VBA's project explorer.
This will then be available to all workbooks open on your machine
Regards
Stephen