Create a Macro in MS Excel Using MS Visual Basic
- by Carol Bratt on 20080826 @ 02:33PM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: macro, developer tab, copy, code group, paste)
This is a different method for creating a macro in MS Excel 2007. You can use this method if you want to write your own script or if you want to copy and paste a part of another macro into an existing macro. You can also use this method to copy and paste a new macro.
Follow the steps below:
If the Developer tab is not available, do one of the following to display it:- Click the Microsoft Office Button, and then click Excel Options.
- In the Popular category, under Top Options for working with Excel, select the Show Developer tab in the Ribbon check box.
- Click OK.
To set the security level temporarily to enable all macros, do the following:
- On the Developer tab, in the Code group, click Macro Security.
- Under Macro Settings, click Enable all macros. Ordinarily, you should not do this as you could allow potentially dangerous code to run.
- Click OK.
- On the Developer tab, in the Code group, click Visual Basic.
- If needed, on the Insert menu, click Module.
- In the code window of the module, type or copy the macro code that you want to use.
- To run the macro from the module window, press F5.
- On the File menu, click Close and Return to Microsoft Excel when you are finished writing your macro.
Feel just like a software developer now don't you?
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
Infopackets Game of the Week: Lottso!
Click any thumbnail to view a full screen sample.
[ Download (Free Trial) ~ 16.52 MB | Read Game Details ]
