Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel training microsoft - excel macros

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Excel Macros

excel training microsoft - Excel Macros

ResolvedVersion Standard

Robin has attended:
No courses

Excel Macros

How do you reduce the security level for Macros to enable them on opening. Can't find this on new 2007 version.

RE: Excel Macros

Hi Robin

You can change the macro security settings in the Trust Center, by doing the following:

Click Microsoft Office Button
Excel Options button
Trust Center category,
Center Settings button,
Macro Settings category

The settings are a bit different to 2003, so here is an article from microsoft on the settings:

http://office.microsoft.com/en-us/excel/HP100969191033.aspx

Regards

Richard

Excel tip:

Navigate with keyboard without losing your active cell

If you like using your keyboard to scroll through your excel document, but want to keep your active cell the same, use the scroll lock, and then use your arrow keys to navigate around the document.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.