Monday 27 July 2015

How to record or run macro from Microsoft Excel 2007?

In Excel 2007 you can record and playback macro from “View” tab, at the right end click at macro you’re able to see the optional either view macro or record macro. Another method is through Developer tab but this tab by default is hidden. To show “Developer” tab you must go to Office button (top left corner) and click, Another window open and click at Excel Options, under “Popular” label you must tick at “Show developer tab in the ribbon” and click OK. Under this “Developer” tab you are able to see Visual Basic Editor, Available Macros, Record Macro, security setting and etc.

Thanks

No comments: