On Mon, 11 Jun 2007 07:44:24 +0200, Jan Karel Pieterse
wrote:

Hi LurfysMa,

These are my own personal macros. How do I enable them without opening
the doors to potential malware?

You can tell Excel 2007 to trust all macros in a specific folder on your
drive:

- click the Office button and choose Excel Options
- Click "Trust Center" and click the "Trust Center Settings" button
- Click the "Trusted Locations" tab and click the "Add new location"
button to add a new folder as a trusted location.
- OK your way back to Excel.

How do I know which folder my VBA macros are in? It's not like a VB
project. I just do Alt+F11.

There are already a number of folders in that list including:

C:\Program Files\Microsoft Office\Templates\
C:\Documents & Settings\Administrator\App Data\MSFT\Excel\XLSTART\
C:\Program Files\Microsoft Office\Office12\XLSTART\
C:\Documents & Settings\Administrator\App Data\MSFT\Templates\
C:\Program Files\Microsoft Office\Office12\STARTUP\
C:\Program Files\Microsoft Office\Office12\LIBRARY\

Might be needed to restart Excel after this to make it work.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com


--