ToolsOptionsSecurity.

Set macro security to "medium".

The go to HelpAboutDisabled Items

If Personal.xls is disabled, enable it.


Gord Dibben MS Excel MVP

On Wed, 5 Jul 2006 12:56:34 -0500, Cincy
wrote:


I am trying to create some macros in Excel that will be available
whenever I open any Excel spreadsheet so I think I need to store the
Macro in my Personal Macro Workbook. When I click record macro and
select store macro in Personal Macro Workbook it is unable to record
the Macro and says "Personal Macro Workbook in the startup folder must
stay open for recording". How do I set my computer so the personal
macro workbook in the startup folder stays open?