Hi Guys,
Spreadsheet has lots of pre installed codes that it uses. ie sum, roundup, etc. Is it possible to add in my own codes so that when i open a new work book they are already available?
Hi Guys,
Spreadsheet has lots of pre installed codes that it uses. ie sum, roundup, etc. Is it possible to add in my own codes so that when i open a new work book they are already available?
Good afternoon jpe1
Yes it is possible.
First you will have to write them using VBA (user defined functions), then install your file as an add-in.
If you do this, then users to whom you send your file will also need your add-in installed to use your file.
The alternative is to use only the UDF's you need in just the files you need them in - then they will "travel" with the file.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Sorry for the slow reply. Thank you for helping me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks