Skip to main content

Tips: How to deploy the excel macros from a central file

By default, when you create a macro for a Microsoft Excel worksheet, that macro works only on that worksheet. This behavior is okay as long the macro automates tasks that are unique to that worksheet. But have you ever found yourself recreating the same macro on more than one worksheet? If you have (and even if you haven't), you can copy your macros to a worksheet called personal.xls. From there, your macros become available to you whenever you start Excel, and you can run them against the data on any open worksheet.
Surely, everyone knows about the Macro feature of the Microsoft Office Application. If you create a Macro for a Microsoft Excel worksheet, that will work only on that particular worksheet. This will be okay as long as the Macro automates the tasks that are unique to that particular worksheet. However, have you ever found a way to recreate the same macro on more than one worksheet? If so, you can copy your macros to a worksheet called personal .xls. Therefore, the Macros will be available to you whenever you start Excel and you will be able to run them against the data on any open worksheet. Moreover, as it is required to be careful here, it is not required to run the Macros at random and doing so will corrupt the data and cost you time and money. But if you have macros that you can use in a variety of situations, using a personal.xls file can also save your time and money.

Now, let’s discuss about starting it.
If you’re going to follow these steps, it is required to open an Excel worksheet that has at least a Macro. If you wish to create a sample Macro, you can follow the following steps.
•    First, start excel and open a new blank workbook.
•    Now, on the Tools menu, point to Macro and then click Visual Basic Editor.
•    Then, in the Project window, it is required to double click ThisWorkbook.
•    After that, copy and paste this code into the code window.
sub test()
MsgBox "This is only
a test."
end sub
5.    After that, it is required to save the file to your default working folder.
6.    Now, it is required to quit the Visual Basic Editor and close the workbook.
Now, let’s discuss about creating a personal.xls file.

If you wish to create and use a personal .xls file, you can follow the following process.
•    Use Microsoft Windows Explorer to create a blank personal.xls file in the folder called XLStart. If you installed Microsoft Office in the default location, you'll find \XLStart under C:\Program Files\Microsoft Office\Office 10. If you installed Office in a different location, find \XLStart there.
•    Hide the file in Excel (Window menu, Hide command).
•    Unhide the file (in the world of Excel, "unhide" is a real word), copy your macros from their parent worksheets to the file, and then hide personal.xls again.
•    If you wish, you can keep the personal.xls file hidden unless you wish to add Macros to it.
•    Whenever you start excel, the personal.xls fill automatically open and run in the background.
•    At the same time, if you don’t wish to hide the file, you will be able to add data to it.

How to hide personal.xls
1.    Start Excel and open personal.xls.
2.    On the Window menu in Excel, click Hide, and then quit Excel.
3.    When asked if you want to save your changes, click Yes. The workbook will open silently and become available 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. Inspired

Google Health Login Page is Ready!

Google's Marissa Mayer announced that the Google Health will be launched on 2008. The service of the Google Health Login Page is ready. It's only the first intro page is displayed and I didn't get passed to the next page. In the same page y0u can see the information displaying on the Google Health. If you point your mouse on the below link you can visit the Google Health Page With Google Health, you can: * Build online health profiles that belong to you * Download medical records from doctors and pharmacies * Get personalized health guidance and relevant news * Find qualified doctors and connect to time-saving services * Share selected information with family or caregivers This will be a nice development about caring health and this will helps in having some cautious about health. Inspired