|
|
| Author |
Message |
boony
Joined: 27 Nov 2006
Posts: 90
|
 Posted: 10/07/07 - 05:47 Post subject: |
 |
|
| Hello. I really have needs to automate some of my work within Excel 2000. I am constantly changing or adding new charts and that operation requires a lot of clicking everywhere. So, I have realized that I need to automate some actions in order to save some of my time. I know that Macros can do this, and I want to build a macro for this, but how? Thanks in advance. |
|
|
Back to top
|
|
|
|
 |
marcello
Joined: 20 Oct 2005
Posts: 108
|
| Posted: 11/12/07 - 03:19 Post subject: |
|
|
| Hi. There are two ways to build a macro. One is to record your mouse and keyboard activities within the Excel it self, and the other is to add some code to the module and to save it. I suppose that you don’t want to mess up with the coding and the programming, so pick up the other method. Click on the Tools>Macros, than record a macro. After clicking on that, perform your every day operation and Excel does all other things by it self. |
|
|
Back to top
|
|
|
|
|
|
