How can I write a macro so that it is available for use for all excel
workbooks that I would open in my Excel 2007. Currently I wrote a macro and
it is working only for the workbook I wrote it under.

Store them in personal.xls

See http://personal-computer-tutor.com/personalxls.htm

"Tigerxxx" wrote:

How can I write a macro so that it is available for use for all excel
workbooks that I would open in my Excel 2007. Currently I wrote a macro and
it is working only for the workbook I wrote it under.

i think i might be trying to do a similar task. this is what i tried, if
it doesnt help, please disregard .




--
infomercialscams

An Excel addin is another way. Whichever way you do this you must make
sure that your code references the correct workbook.


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95209

Hi,

How can I reference my code so that it points to "All" workbooks that I
would open in Excel?

"royUK" wrote:


An Excel addin is another way. Whichever way you do this you must make
sure that your code references the correct workbook.


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95209

When I have generic macros that I want available whenever I open excel, I'll
write the code to use the activesheet--or even use the current selection.

And those kinds of generic macros would go in my personal.xls/.xla workbook.

If I need something that only runs against certain workbooks (or even certain
types of workbooks), I won't put those macros in my personal.xl* workbook. I'll
create a specific workbook/addin for just those utilities.

Those types of macros may need a second sheet--or look for sheets with specific
names (or range names).

Tigerxxx wrote:

Hi,

How can I reference my code so that it points to "All" workbooks that I
would open in Excel?

"royUK" wrote:


An Excel addin is another way. Whichever way you do this you must make
sure that your code references the correct workbook.


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95209



--

Dave Peterson