Selva has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
Excel Pivot Tables course
Excel PowerPivot course
.xla Format
Hi Anthony,
I saved an .xls file with macros as .xla and when I opened the file there were no deatils. How do I link the add ins?
Thanks
Selva
RE: .xla Format
Hi Selva, thanks for your query. Go to Tools > Add-Ins to open the Add-Ins dialog and use the [Browse] button to find it. Place a tick in the check-box next to your Add-In's name and click [OK]. Your macros should now be accessible but check the macro security settings on your machine (possibly also with IT if you can't see the macros).
Hope this helps,
Anthony