Forum Discussion
Where is the file: ATPVBAEN.XLAM on my Mac?
I'm trying to use VBA to automate histogram creation. I'm using Excel 2019 on a Mac and have the data analysis toolkit installed and working. I wrote the simplest of programs: Sub tryHisto()...
The add-in you refer to is a separate one from the Analisys Toolpak. Does your add-ins dialog contain this entry: "Analisys Toolpak - VBA"? If so, check it and you should be good to go. If not, I'm not sure whether this add-in is part of a Mac Office installation.
Thanks. Apparently the Analysis Toolpak VBA is not available on the Mac. JKPieterse