3.0 Use
The Trouble Shooting Guide Below...
Do the above BEFORE you try running
our applications. If you then encounter any problem,
follow the troubleshooting guide(obtained in part
from MS Excel) below.
1)
Default Macro security setting in your copy of Excel
is likely to be minimum of "High"
which will cause applications like ours to be automatically
disabled. You can use the following procedure to enable
the macro:
Close the file
and any other instances of the application currently
running on the computer (this may include closing
any applications using portions of the application
you are currently running, such as Outlook which can
use Word, database applications, and others).
a) Select the Tools
menu option and then select Macro and Security. In
the resulting Security dialog, set the security level
to Medium by clicking the Medium radio button. Close
the file and any other instances of the application
currently running on the computer.
b) Open the file again
and click the Enable button when prompted to allow
for the unsigned macro to run.
NOTE:
In the event that you do purchase any of
our applications, that you may want to set the security
level to "Low" by clicking the "Low"
radio button. This will eliminate the need to answer
the "Enable/Disable Macros" prompt every
time you open the application. Keep
in mind however that this should only be done if you
are sure adequate anti-virus protection exists on
your PC as other macros-driven applications (from
other sites you might patronize) could pose virus-attack
threats. The next line of instruction is therefore
very important:
c) When you have accepted
the macro, return the macro security level to High.
IF OUR APPLICATION STILL
DOES NOT RUN - THE FOLLOWING ARE TROUBLESHOOTING TIPS
THAT SHOULD HELP YOU FIND OUT WHY AND HOW TO RECTIFY
THE PROBLEM:
2)
Another instance of your application has a lock on
the security settings and is disallowing any
changes to security settings. It is recommended to
close all Office related applications or other instances
of the same application when you attempt to make changes
to your security settings.
3) Visual Basic for
Applications (VBA) is not installed on your computer
If VBA is not installed,
it is not possible to accept certificates of trust
attached to VBA macros. Therefore, any VBA macro attempting
to run, even with an attached certificate of trust,
cannot be run because the necessary macro interpreter
is not installed on the system. Two scenarios can
cause this error:
a)
Your administrator chose not to install VBA :
The version of Office you are running does not install
VBA by default. If you are running an instance of
Office that does not provide VBA as an installable
feature, you will need to upgrade your version of
Office to run VBA macros.
b)
The certificate of trust is invalid - (when
this occurs, you cannot select the Enable button).
The certificate is no longer trusted, was revoked
by the issuing authority, or is damaged. There are
several other possibilities which you may need to
explore as to why the certificate is no longer recognized
as valid by your system. It
is recommended that you never trust or run a macro
that has an invalid certificate. A troubleshooter
help topic is available online regarding this issue.
Back
to top
|
