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

JCIrish,

Depending on the version of XL you are running, there is an XLStart folder,
e.g. C:\Program Files\Microsoft Office\OFFICE11\XLStart

Any Excel file placed in this folder will automatically open when you launch
Excel.

Also Excel has a number of start up switches that you can put in the target
for the shortcut. These switches provide additional flexibility. Consult the
Excel help for detailed instructions.

MC

"JCIrish" wrote in message
...
I'm a novice at VBA Excel macro writing (Excel 2000). I'e read that I can
store macros in personal.xls and they will be abailable to all of my
workbooks. But, I don't seem to have personal.xls on my computer(I've
searched where it's supposed to be, as far as I know). Can (how do) I
create
this workbook and then use it.



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 and personal.xls John Kilkenny Excel Discussion (Misc queries) 1 June 14th 05 09:43 PM
Getting rid of personal.xls Gregg[_3_] Excel Programming 5 September 12th 04 12:48 AM
Personal.xls R. SRIKANTH[_2_] Excel Programming 1 February 10th 04 09:52 AM
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 04:09 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"