Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 788
Default Saving Macro to Personal Workbook

When trying to save a macro to my personal macro workbook, I get the message:

'Personal Macro workbook in the startup folder must stay open for recording'

It then fails to save to macro.

Any ideas why this is occuring?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Saving Macro to Personal Workbook

Chris

From a post by Dave Peterson....................................

Maybe personal.xls was disabled...

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

End Dave's post..............................................


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 09:22:02 -0800, Chris
wrote:

When trying to save a macro to my personal macro workbook, I get the message:

'Personal Macro workbook in the startup folder must stay open for recording'

It then fails to save to macro.

Any ideas why this is occuring?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro or OLE method to insert worksheet from template workbook Lyndon Rickards Excel Discussion (Misc queries) 0 January 30th 06 08:46 PM
Excel's Personal Macro Workbook Excel User Excel Worksheet Functions 1 January 26th 06 07:15 PM
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
Issuing macro in workbook from separate workbook Nigel Excel Discussion (Misc queries) 1 May 16th 05 05:46 PM
Extract specific data into its own workbook via macro? Adrian B Excel Discussion (Misc queries) 2 February 24th 05 06:09 AM


All times are GMT +1. The time now is 09:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"