Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 691
Default PERSONAL worksheet problems

Is your personal.xls workbook hidden (it should be)
Window -- hide workbook

Had you used Excel to back up your personal.xls

Tools, options, General
is the alternate startup blank or do you have something in it
if you you do is there a personal.xls in it.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"davegb" wrote in message oups.com...
Steve,
Thanks for your reply. I already checked for mulitple instances. There
is only one on my C drive. I have copied it to my H (network) drive to
back it up, but I didn't think XL would find it there. Is that correct?


STEVE BELL wrote:
You may have more than one Personal.xls in your system. It is possible you
have more than 1 Startup folder.

A quick way to find them is to unhide one and open File Properties to see
where it is.
Open the other and do the same.

You are allowed as many as you want - but the names must be different.

Find them and either rename one of them or get rid of it.

If you decide to get rid of it
Rename it
Compare them and consolidate all your code
Dump one of them

--
steveB

Remove "AYN" from email to respond
"davegb" wrote in message
oups.com...
I have a number of general purpose macros in my PERSONAL worksheet. But
the first time I access any of them, XL tells me that there is an
instance of PERSONAL already open (PERSONAL automatically opens when I
open XL), and it can't open another with the same name. I have to close
PERSONAL, the run the macro, which opens PERSONAL. Then I can run the
macros again. Irritating to say the least. Is there a better way?




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
my personal.xls file is causing problems Chrisinct Excel Discussion (Misc queries) 3 December 7th 06 03:28 PM
problems with personal.xls jdusina Excel Discussion (Misc queries) 1 January 5th 06 01:54 AM
Problems with Personal.xls Cal[_3_] Excel Programming 1 April 21st 04 08:24 PM


All times are GMT +1. The time now is 08:13 PM.

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"