Skip to main content

Tips: How to add new and existing macros in Excel

If you create a new Macro, you can choose to save it to your personal.xls file. Moreover, if you wish, you can add your existing Macros to the personal.xls file. Go through the following steps to perform both the actions.
How to add new macros
1.    It is required to point to Macro from the Tools menu.
2.    Now, select the Record New Macro option.
3.    After that, it is required to select Personal Macro Workbook in the Store Macro In list.
4.    Then, click OK to add your Macro normally.

How to add existing macros
1.    Open personal.xls, and on the Window menu, click Unhide.
2.    In the Unhide dialog box, ensure that personal.xls is selected, and then click OK.
3.    Open the worksheet that contains the macro you want to copy, and on the Tools menu, point to Macro, and then click Macros.
4.    Select the macro you want to add to personal.xls, and then click Edit. This step starts the Visual Basic Editor and opens the code module for the macro.
5.    On the File menu in the Visual Basic Editor, click Export File.
6.    Locate the \XLStart folder and click Save to save the code module in that folder.
7.    Go back to personal.xls, press ALT+F11 to start the Visual Basic Editor there, and on the File menu, click Import File.

8.    Navigate to the \XLStart folder, click the module that you just exported, and then click Open.
9.    Save the module, quit the Visual Basic Editor, and then hide personal.xls (Window menu, Hide command). Quit Excel, clicking Yes to save your changes.
10.    One final task: Go back to the \XLStart folder and delete any code modules. If you leave the module files in the folder, they appear automatically the next time you start Excel.

B y

Popular posts from this blog

New Micro battery, power packed for high performance

For a size of a few millimetres, the new micro-batteries are powerful enough to jump start a car battery and then quickly charge the cell phone. Researchers from the University of Illinois have developed the micro batteries which can be used to drive compact electronic devices and new applications for radio communications. The micro batteries are so good that they can even out power the super capacitors. The results were published in ‘Nature Communications’ in the April 16 issue. The micro batteries have energy and power and with the researchers tweaking the structure of the micro batteries a little bit, its use can be for wide range applications.

The high performance of the micro battery is based on its 3-dimensional micro-structure. Based on the design of fast charging cathode by Professor Paul Braun’s group, researchers developed the matching anode and integrated it with the fast charging cathode at a micro-scale and made a complete battery with high performance. These batteries cou…

HTC Touch Diamond SmartPhone!

The phones design is an innovative in which the user has the geometric form language to make sure a clutter-free environment for screening content. The San Francisco based studio One & Co collaborated with HTC Taiwan Design team to create Diamond HTC smartphone.

The HTC phone is quite wonderful with design and the rapid development in the smartphone market the HTC has taken innovative steps to capture the SmartPhone market HTC develops these kind of new inventive designs.

How to Automatically Convert any RSS Feed to an iPhone Web app!

For iPhone users this is another web app which converts any well formed XML RSS feed to an iPhone version. It is possible because it is worked with the typical sliding style interface to suit the iPhone optimized version. For instance if you had the iPhone right now here is the Google News Feed

Jim Liddle, one of the creators of the service, told iPhone Atlas “You can book mark the generated site and use it to host your own content and reference it from your own. It seems that these feed on your iPhone is quiet usable.