To view the macro security settings in Excel 2007 please
navigate to: Office Menu / Excel Options / Trust Center /
Trust Center Settings / Macro Settings.
On first use of litLIB please ensure that the macro
settings are not set to the first option (So do NOT disable
all macros without notification). Please use the second
option: Disable all macros with notification or set a lower
macro security.
When litLIB starts for the first time you will see a
Security Warning just like in the screen print
below. Press the Options button to enable the macros in
litLIB.
The Security Options dialog will be shown. Please
allow l code from us to run (select the last option). After
having made this selection you can go back to the Trust Center
to set the macro settings to disable all macros without
notification.
litLIB will add a section to the
Formulas tab in the ribbon. Clicking the insert function
button the Insert litLIB function screen will be shown.
Select the function you want to use. In our example we
selected the Absolute function to compute the absolute value
of a number. The basic help message is displayed with
parameter help. It is recommended to use the Help on this
function button to show a web page with more information about
the command.
After the function was selected the regular Excel
function panel will display. Just complete the parameters and
the result will show in Excel.
Copyright (C) 1995-2010 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap