Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Personal.XLS

Zack,
Are you sure about your statements below ?
In W2K at least, multiple instances of Excel still get Personal.xls, but
read-only, hence the dialog, if started from the menu.

NickHK

"Zack Barresse" wrote in message
...
Hello Rafi,

Your Personal.xls is by default designed to open everytime you open an
instance of Excel. It will not open (again) if you open multiple

instances
and won't be available in the subsequent instances. If you have a routine
in a standard module of your Personal.xls and it is not private (or the
module) then you should see it by hitting Alt + F8 from Excel.

Is this not the case? Are you sure you *have* a Personal.xls and is it in
your XLSTART folder?

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Rafi" wrote in message
...
How do I make a macro in Personal .xls available on other worksheets
without
having to open Personal.xls explicitly? I have a file that I get twice

a
day
that needs to undergo some modifications which are stored in a macro in
personal.xls. I open Excel by Dbl-Clicking my .xls file however, the
macros
I have stored in Personal.xls are not visible or available.

Thanks





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.xls Lin Excel Discussion (Misc queries) 2 January 7th 10 07:36 PM
Personal.xls Guy Incognito Excel Discussion (Misc queries) 2 September 22nd 05 07:52 PM
Personal macro workbook and personal.xls John Kilkenny Excel Discussion (Misc queries) 1 June 14th 05 09:43 PM
personal.htm & personal.xls in Macro Rasoul Khoshravan Azar Excel Programming 0 January 21st 04 05:27 PM


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