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:
Subscribe to: Posts (Atom)