Thursday, 15 November 2012

Open an add-in dialog box from Excel Options

Click the Office button, click Excel Options
Click the Office button, click Excel Options
Click Add-ins, click the Manage list arrow,
 click Excel Add-ins or COM Add-ins
Click Add-ins, click the Manage list arrow, click Excel Add-ins or COM Add-ins
Click Go.
Click Go.
Posted by at No comments:

Manage Installed Add-ins

Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Add-Ins. 
           Click the Manage list arrow, and then click the add-in list:
           COM Add-ins.
           Excel Add-ins.
           Smart Tags.
           XML Expansion Pack.
           Disabled Items.
In the left pane, click Add-Ins. Click the Manage list arrow, and then click the add-in list:
Click Go.
Click Go.
Click OK.
Click OK.
Posted by at No comments:

View Installed Add-ins

Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Add-Ins.
In the left pane, click Add-Ins.
Click an add-in to display information about it.
Click an add-in to display information about it.
Posted by at No comments:

Change Macro Security Settings

Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Trust Center. Then click Trust Center Settings.
In the left pane, click Trust Center. Then click Trust Center Settings.
In the left pane, click Macro Settings. Select the option for macros: 
             Disable all macros without notification, 
             Disable all macros with notification, 
             Disable all macros except digitally signed macros, 
             Enable all macros.
Select the option for macros: Disable all macros without notification, Disable all macros with notification, Disable all macros except digitally signed macros, Enable all macros.
If you're a developer, select the Trust access to
 the VBA project object model check box.
If you're a developer, select the Trust access to the VBA project object model check box.
Posted by at No comments:

Create a self-signing certificate for a macro project

Click Digital Certificate for VBA Projects under Office Tools
Click Digital Certificate for VBA Projects under Office Tools
Enter a name, and then click OK.
Enter a name, and then click OK.
Office programs trust a self-signed certificate 
only on the computer that created it.
Posted by at No comments:

Sign a Macro Project

Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Popular. Select the
 Show Developer tab in the Ribbon.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
Click the Developer tab. Click the Visual 
Basic button to open the Visual Basic window.
Click the Developer tab. Click the Visual Basic button to open the Visual Basic window.
Click the Tools menu, and then click Digital Signature.
Click the Tools menu, and then click Digital Signature.
Click Choose.
Click Choose.
Select a certificate in the list.
Select a certificate in the list.
To view a certificate, click View Certificate, and then click OK.
To view a certificate, click View Certificate, and then click OK.
Posted by at No comments:

Open a Workbook with Macros

Click the Office button, and then click Open.
Click the Office button, and then click Open.
Click the workbook with macros you want to open, and then click Open.
Click the workbook with macros you want to open, and then click Open.
Click Options in the Security Warning.
           Click OK.
Posted by at No comments:

Save a Workbook with Macros

Click the Office button, and then click Save As.
Click the Office button, and then click Save As.
Type a workbook file name.
Click the Save as type list arrow, and then select:
Excel Macro-Enabled Workbook. A workbook (.xlsm) that
contains VBA code.
or Excel Macro-Enabled Template. A template (.xltm) 
that includes preapproved macros.
Excel Macro-Enabled Template. A template (.xltm) that includes preapproved macros.
Click Save.
Click Save.
Posted by at No comments:

Record a Macro

Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Popular. 
           Select the Show Developer tab in the Ribbon.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
Click the Developer or View tab.
Click the Developer or View tab.
To record a macro with actions relative to the 
initially selected cell, click the Use Relative References button.
To record a macro with actions relative to the initially selected cell, click the Use Relative References button.
Click the Record Macro button.
Click the Record Macro button.
Type a name for the macro. Assign a shortcut key to run the macro.
Type a name for the macro. Assign a shortcut key to run the macro.
Click the Store macros in list arrow, and then select:
           Personal Macro Workbook to use the macro whenever you use Excel.
           New Workbook to use the macro in new workbooks.
           This Workbook to use the macro only in this workbook.
Click the Store macros in list arrow, and then select:
Type a description. Click OK.
Type a description. Click OK.
Execute the commands.
Execute the commands.
Click the Stop Recording button
Posted by at No comments:

Edit a Macro

Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Popular. 
           Select the Show Developer tab in the Ribbon.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
Click the Developer or View tab. Click the Macros button.
Click the Developer or View tab. Click the Macros button.
Click the macro you want to edit, and then click Edit.
Click the macro you want to edit, and then click Edit.
Click the Module window containing the Visual Basic code.
Click the Module window containing the Visual Basic code.
Edit the commands already present
Posted by at No comments:

Debug a Macro Using Step Mode

Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Popular. 
           Select the Show Developer tab in the Ribbon.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
Click the Developer or View tab.  
           Click the Macros button.
Click the Developer or View tab. Click the Macros button.
Click the macro you want to debug. Click Step Into.
Click the macro you want to debug. Click Step Into.
The Microsoft Visual Basic window opens.
The Microsoft Visual Basic window opens.
Click the Debug menu, and then click Step Into to
 proceed through each action.
Click the Debug menu, and then click Step Into to proceed through each action.
Posted by at No comments:

Friday, 2 November 2012

Delete a Macro

Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Popular. 
           Select the Show Developer tab in the Ribbon.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
Click the Developer or View tab. 
           Click the Macros button.
Click the Developer or View tab. Click the Macros button.
Click the macro you want to delete. 
           Click Delete.
Click the macro you want to delete. Click Delete.
To stop a macro. Press Ctrl+Break to stop a macro
Posted by at No comments:
Subscribe to: Posts (Atom)