Macros and VBA

Help protect your computer by disabling potentially damaging Excel 2003 macros.

With the macro below you can insert pictures at any range in a worksheet. The picture can be centered horizontally and/or vertically.....

Private Profile Strings are often used to store user specific information outside the application/document for later use....

If you don't want to use API-functions you can use Words object library to read and write Private Profile Strings....

Private Profile Strings are often used to store user specific information outside the application/document for later use....

If you have trouble with the docking of the different VBE windows, you can restore their positions by editing a setting in the Registry....

Insted of using several unique variables to store information, you can use an array variable. When you know how many elements you need to store in the array, you can use a static array variable like this ....

The macros below will display a list of all installed fonts. Note! If you have many fonts installed, the macro may stop responding because of lack of available memory....

The macro below will display a list of all installed fonts. Note! If you have many fonts installed, the macro may stop responding because of lack of available memory. If this happens you can try the sample for Word later in this document.....

With the macros below you are able to open and close the CD-ROM tray/door.....