In this article, we will use change event of worksheet to protect cells which contain formulas. Raw data consists of employee sales data, which inclu...
Excel Add-Ins An Excel Add-In is a file (usually with an .xla or .xlam extension) that Excel can load when it starts up. The file contain...
Open Excel and the VBE (Visual Basic Editor). Unless it has been changed, the VBE window contains the Project Explorer window and the Properties wind...
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...
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 ...
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, _...
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 ...
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.
