Excel 2007 - Macros

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

Resolved · Low Priority · Version Standard

Excel 2007 - Macros

Gemma has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Gemma [2 posts] (2008 Mar 12 Wed, 15:32) Reply

On spreadsheets where macros have been created, when opening the spreadsheet at a later time the macros are not enabled. How can i keep the macro on a spreadsheet enabled without having to go through the security dialog to enable it again?

Thanks

Gemma

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu	Bloomsbury	2	book now	£215	£215
2007	2009 Jan 8 Thu	Bloomsbury	3	book now	£224	£224
2007	2009 Jan 12 Mon	Bayswater	4	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	2	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
Full Schedule: See all 136 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: Excel 2007 - Macros

by - delegate Samantha [21 posts] (2008 Mar 13 Thu, 13:10) Reply

I did this by using a Digital Signature on the macros and setting the security to High.
Once the macros as digitally signed, and you have set up a Signature from a trusted publisher (you can create one yourself), the enable/disable macro box will not be shown.
You have to register your dig sig yourself.
if you search for Digital Signatures, you will find a lot about it on the microsoft web site.

· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Fun Things I've Done With Excel
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Creating Charts with Excel
· Why Should I Learn Visual Basic in Excel?

Please browse our web site to find out more about
microsoft-excel-training and other Microsoft training courses.

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

Rate this page: