Of most ways to automate and extend Microsoft Excel with VB, most effective is to record own macro. Next, examine code made by macro recorder and start making small alteration to it.

• Run Excel and Press "alt + F" keys from your keyboard, then select "Options." Click "Trust Center," then select "Trust Center Settings". Select "Macro Settings", then Press "Enable all macros." Tick "Trust access to the VBA project object model." Press "OK".

• Select macro recording. Press "OK".

• Hit "alt + f," then select "Options." Select "Advanced", tick "Show all windows on the Taskbar." Hit "OK".

• Click "stop recording", then press "alt + F8" to view list of macros. Click "macro1,", and Select "Edit".

• Press "alt + f11," then press "alt+ F8" to view list of macros. Select macro ("macro1"), then select "Options." Enter "k" in small box where it says "shortcut key: Ctrl + [ ]", then hit "OK." Close "Macro" dialog box on return.

• Push "control+k".

• Hit "control-n" few times to make new workbooks. Watch Windows taskbar carefully to do this. Every new window will show in taskbar if macro's message displayed "...ON...," One window will show if macro is "OFF."

• Hit "control+s" to store workbook. In "save as type" box, select "Excel Macro-enabled Workbook." Enter any filename and "Save."

• Go back to program code for macro, from instructions from step number 4. Change macro to use a less way of viewing its status message to user, by swapping "MsgBox..." declaration with following:

Application.StatusBar = "Show all Excel windows is " & s

• Go back for Excel and run to the macro.