Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
You could place the UDF in Personnal.xls as long as it is open it will be available to all Workbooks.
Make sure it is a Public Function
not Private Function.
Dont have Option Private Module in declarations.
I save as an add-in (.xla) for this, you can save the workbook anywhere just place a shortcut to it in your XLStart directory and it will open with Excel.
If you want stand alone workbooks to give to others its probably best to copy it to those workbooks.
Hi in line with the suggestions above I tend to dislike Personal.xls at work, on network or imager / remote installations and data drive swooping, and line stripping read write profiles ad all the rest Personal.xls is not so good [sorry extremely technical scenarios listed, but just for the technical readers to enjoy]
I would as has been suggested looking at a location to store XLA files and have this access unrestricted to read access but locked to write access, and all that needs to be done is load the XLA in the correct fashion and this add in will load as Excel fires on all work stations via network access.
The same scenario will use this utilisation of XLA on a local install / work station just the same, a good habit to get into for the future.
My vote ? XLA.
BTW its worth adding if the administrator is cleaver the out of hours update can be done and just a reload can be made for the updates if the case is necessary.
Just as you can rename old XLA and name new XLA to link with current settings, nut in the passed this can fail for some odd reason.
Hope this helps
Jack in the UK
Don’t have an account yet? Register yourself now and be a part of our community!
