excel training microsoft - Excel Macros

The UK's most regular instructor-led training courses.
Training information: excel training microsoft · Microsoft+excel+training · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel Macros

Robin has attended:
No courses

by - delegate Robin [1 post] (2007 Aug 15 Wed, 11:35) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 27 Thu	Bloomsbury	4	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	3	book now	£224	£235
2003	2008 Dec 5 Fri	Bayswater	6	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
Full Schedule: See all 99 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel Macros

by - trainer Richard platinum contributer [813 posts] (2007 Aug 16 Thu, 10:10) Reply

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

· Benefits of learning about Excel charts
· Identifying Suitable Candidates For VBA For Excel Training
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Interesting Lifestyle Applications for Microsoft Excel
· Why Should I Learn Visual Basic in Excel?

Excel tip:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

View all Excel hints and tips