The short answer is that likely you are running the Office application somehow with admin rights (privileges), while your administrator user account would allow you to run it without admin rights. If you really need to use the Office application with admin rights, then uninstall MZ-Tools 8.0 for VBA (which was installed without admin rights), download the latest version of MZ-Tools 8.0 for VBA, right-click the MZTools8VBASetup.exe file and click "Run as administrator" context menu entry to install it again, but this time with admin rights.
The long answer is:
On Windows Vista or higher (with its User Account Control - UAC feature activated), there are two types of user accounts:
- Standard User Account, with no chance of getting admin rights.
- Administrator User Account, which in turn can run applications in two modes:
- Without admin rights, as if it was a standard user account. This is the default if UAC is activated. In other words, the administrator user account doesn't have admin rights most of the time.
- With admin rights ("elevated" mode). This is not the default mode and requires some action to use it, such as using the "Run as administrator" context menu entry or going to the properties window of the application shortcut or executable, Compatibility tab, and checking the "Run this program as an administrator" checkbox. You get a "consent prompt" to enter this "elevated" mode and get the admin rights.
That explained:
- The setup of MZ-Tools 8.0 for VBA, on the contrary to most setups, doesn't require admin rights to install. Any user account, standard or administrator, can install it. In fact, if your user account is administrator user account, the setup should not be executed with admin rights in "elevated" mode (do not right-click "Run as Administrator" to run it).
- The Office applications must be executed without admin rights. This is the default configuration after the Office setup has run. Unless you change it, Office applications run without admin rights, which is safer.
Both requirements (to run the setup and the Office applications without admin rights) are very easy to meet, because they are the default. The technical reason for them is that MZ-Tools 8.0 for VBA uses per-user COM-registration (instead of machine-wide COM-registration, which would require admin rights to install). But using per-user COM-registration implies that the Office application of the VBA editor must run without admin rigths (not "elevated"), because a process running with admin rights cannot use per-user COM-registration (it can use only machine-wide COM-registration).
Finally, the error 'MZ Tools 8.0 for VBA could not be loaded' happens when two conditions are true:
- The setup has been installed without admin rights, which is correct.
- The Office application is running somehow with admin rights, in "elevated" mode, which is not required in most cases. Do not use the "Run as administrator" context menu and ensure that the "Run this program as an administrator" checkbox of the Compatibility tab of the properties window of the application shortcut or executable is not checked. If you know what you are doing and really need to use the Office application with admin rights, then uninstall MZ-Tools 8.0 for VBA (which was installed without admin rights), download the latest version of MZ-Tools 8.0 for VBA, right-click the MZTools8VBASetup.exe file and click "Run as administrator" context menu entry to install it again, but this time with admin rights. That will use machine-wide COM-registration instead of per-user COM-registration and will solve the problem.