Eliminate screen flashing while running a macro using VBA in in Microsoft Excel

Enter the code line at the begining of the code: Application.ScreenUpdating = False Enter the code line at the end of the code to turned back the sc...

Change the cursor appearance to hourglass using VBA in Microsoft Excel

When you have a big vba macro / code which needs to run for many minutes, you can change the cursor to the hourglass or waiting cursor (based on your ...

Open and close the CD-ROM tray using VBA in Microsoft Excel

With the macros below you are able to open and close the CD-ROM tray/door. Declare Sub mciSendStringA Lib "winmm.dll" (ByVal lpstrCommand As String, _...

Display all installed fonts (Excel) using VBA in Microsoft Excel

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 ...

Display all installed fonts (Word) using VBA in Microsoft Excel

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...

Playing sound notes using VBA in Microsoft Excel

In Excel 5 and 95 it is possible to attach notes to a cell using a sound file. This soundnote kan be played back by opening the dialog for editing of...

Restore the VBE windows to their default positions using VBA in Microsoft Excel

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube