Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help

Buy now

Download now

LITlib - Excel Power Functions Pack
 
First use in Excel 2000 

In Excel 2000 litLIB can be run with the highest macro security settings.

When Excel is opened the first time after the installation of litLIB the following security dialog will show if you have set the macro security to high. In this dialog you need to indicate that you trust software from us - Linker IT Software B.V.

  security

The litlIB software will show up in 2 places in Excel 2000. In the insert menu you will find a new LITlib function menu item. On the toolbar there is a shortcut (the seconds fx icon) to the litLIB Insert Function dialog.

interface

In the Insert function dialog you need to pick a category and within the category a function. 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.

In the example below the DaysInMonth function is selected which returns the number of days in a given month. 

Example

After a function was selected the regular Excel function panel will display. Just complete the parameters and the result will show in Excel.

Another example

Yet another example

 

litLIB