Happy_Dog
Networkdays does not work unless user has Analysis Toolpak installed. You can overcome this by installing it via code in your workbook.
To do this use, say, the Open event for the workbook to test whether or not it is installed. If not, install it:
- Open VBE (Alt+F11)
- double click ThisWorkbook
- in the code page, cut and past this
Private Sub Workbook_Open()
If AddIns("Analysis toolpak").Installed = False Then AddIns("Analysis toolpak").Installed = True
End Sub
Now, each time the workbook is opened it check to see if the toolpak is installed. If it is not, it will install it. This then permits the function to operate.
Any help?
Regards
Robb__