HighDots Forums  

Global Macros in EXCEL

Macromedia Dreamweaver Macromedia Dreamweaver Discussions (macromedia.dreamweaver)


Discuss Global Macros in EXCEL in the Macromedia Dreamweaver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jordan Marton
 
Posts: n/a

Default Global Macros in EXCEL - 07-16-2003 , 10:21 AM






Hi, I am writing a simple VB macro in excel to work along with some of my
database reports... The problem is, I want it available everytime I open
excel, not in a particular file only. I read somewhere that to do that, I'd
have to edit the Personal.xls file. I did, and added my macro to that, and
yes, it seems to appear in every new workbook. however, if I try to open two
new excel files at once, I get a warning saying that:

PERSONAL.XLS is locked for editing by Jordan Marton.
Click notify to open a read only copy of the document...

How can I avoid this? Is there another way to accomplish what I awnt to do?

Jordan



Reply With Quote
  #2  
Old   
Gary White
 
Posts: n/a

Default Re: Global Macros in EXCEL - 07-16-2003 , 01:28 PM






On Wed, 16 Jul 2003 15:21:48 +0100, "Jordan Marton"
<JMarton (AT) HAHAmarketaxess (DOT) com> wrote:

Quote:
PERSONAL.XLS is locked for editing by Jordan Marton.
Click notify to open a read only copy of the document...
You should not get that if you open both in the same instance of
Excel.


Gary


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.