Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 397
Default Unable to Unhide Personal Macro workbook

Howdie,

For some reason the Unhide option under the Window menu is greyed out...

Also if I try and record a Macro, and specify it to be stored in
personal macro workbook, I get an error that says Personal Macro
workbook in the startup folder must stay open for recording... any
ideas...?
Sounds like I dont have a personal macro workbook, and need to re-create
one...?

Thanks

D



*** Sent via Developersdex http://www.developersdex.com ***
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Unable to Unhide Personal Macro workbook

Maybe it was disabled...

xl2002+ have 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'll want to put your backup copy in XLStart.

Darin Kramer wrote:

Howdie,

For some reason the Unhide option under the Window menu is greyed out...

Also if I try and record a Macro, and specify it to be stored in
personal macro workbook, I get an error that says Personal Macro
workbook in the startup folder must stay open for recording... any
ideas...?
Sounds like I dont have a personal macro workbook, and need to re-create
one...?

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 397
Default Unable to Unhide Personal Macro workbook


You're a genius!! Works perfectly! Thanks




*** Sent via Developersdex http://www.developersdex.com ***
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
Personal Macro Workbook Vision2279 Excel Worksheet Functions 1 November 22nd 06 03:40 PM
Personal macro workbook and personal.xls John Kilkenny Excel Discussion (Misc queries) 1 June 14th 05 09:43 PM
Personal.XLS MACRO Workbook Don Excel Programming 8 February 10th 05 05:19 PM
personal macro workbook helmekki[_6_] Excel Programming 4 June 3rd 04 02:52 AM


All times are GMT +1. The time now is 02:29 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"