Question about Microsoft Office Standard for PC
Pls say for excel
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
SOURCE: macro on excel
Macros are a timesaving feature that allow you to record a sequence of actions that you do in excel, and replay them back later.
You give each macro a name, and you can invoke them later, and Excel will "do" whatever it is you did when you recorded the macro.
To record a new macro:
1) Open Excel
2) Go to Tools->Macros->Record New Macro...
3) Type in a name for your macro and hit OK
(A new toolbar will popup with a "stop" button on it. Excel is now recording everything you do)
4) Do something, like, for example, select some cells and make them bold.
5) Click the "stop" button.
Now your macro has been recorded! You can play it back later by:
1) Open Excel
2) Go to Tools->Macros->Macros...
3) Select your macro from the list
4) Click "Run"
The actions you performed earlier will now be executed.
Macros are written in Visual Basic for Applications, or "VBA". It is a programming language which uses the Excel Object Model to perform various actions. You can edit and create custom macros by writing the code manually in VBA. To do this:
1) Open Excel
2) Go to tools->macros->macros...
3) Select an already existing macro
4) Click "Edit"
(The visual basic editor will open, showing you the code for your macro)
At this point you are writing a program in Visual Basic. To learn how to edit macros, you need to learn visual basic, as well as the specific quirks related to excel macros in visual basic.
Recording a macro, and then using it as a template while you edit it is a common trick for making macros manually more quickly.
If you are not familiar with VB, I would not suggest attempting to edit your macros in any but the most simplest of ways. If you're brave, you can try to learn about editing macros in VBA here:
Posted on Jan 28, 2008
Tips for a great answer:
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
Feb 21, 2011 | Computers & Internet
Apr 08, 2010 | Microsoft Office Excel 2007
Feb 17, 2010 | Computers & Internet
Jan 14, 2010 | Computers & Internet
Sep 23, 2009 | Microsoft Office Excel 2003 for PC
Aug 18, 2008 | Microsoft Excel for PC
May 06, 2008 | Microsoft Excel for PC
Jan 28, 2008 | Computers & Internet
Jan 26, 2008 | Computers & Internet
57 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: