In response to a question on allowing a macro to be available for all files
in Excel dated 5/17/09, FST1 wrote a solution that did what was requested.

Namely:
C:\Program Files\Microsoft Office\Office12\XLSTART (i think).
The file will open automaticly(hidden) when excel starts and all macros in
the personal.xlsb will be available for use on all files.

My question is can the same be done for certain Excel workbooks but not
others?

Any help will be greatly appreciated.

Jim Walsh

hi
you seem to have two questions.
subject:Separate macro from workbook.
no. can't be done.
not sure about your second question. if it's in the xls start folder, it
will open with excel and all macros in the open workbooks can be use on other
files provided they are generic ie make no reference to a specific workbook
name or worksheet name.

if i didn't answer your question, post back with more detail.

Regards
FSt1

"jswalsh33" wrote:

In response to a question on allowing a macro to be available for all files
in Excel dated 5/17/09, FST1 wrote a solution that did what was requested.

Namely:
C:\Program Files\Microsoft Office\Office12\XLSTART (i think).
The file will open automaticly(hidden) when excel starts and all macros in
the personal.xlsb will be available for use on all files.

My question is can the same be done for certain Excel workbooks but not
others?

Any help will be greatly appreciated.

Jim Walsh

You answered the real question, which was can the macros and the workbook be
separated.

What I was trying to do was to save changes in the workbook and not save
changes in the macros.

Any ideas on that one?

Thanks,

Jim Walsh


"FSt1" wrote:

hi
you seem to have two questions.
subject:Separate macro from workbook.
no. can't be done.
not sure about your second question. if it's in the xls start folder, it
will open with excel and all macros in the open workbooks can be use on other
files provided they are generic ie make no reference to a specific workbook
name or worksheet name.

if i didn't answer your question, post back with more detail.

Regards
FSt1

"jswalsh33" wrote:

In response to a question on allowing a macro to be available for all files
in Excel dated 5/17/09, FST1 wrote a solution that did what was requested.

Namely:
C:\Program Files\Microsoft Office\Office12\XLSTART (i think).
The file will open automaticly(hidden) when excel starts and all macros in
the personal.xlsb will be available for use on all files.

My question is can the same be done for certain Excel workbooks but not
others?

Any help will be greatly appreciated.

Jim Walsh

hi
no really. the vb part and the file are intergrated. saving saves all. if
there is a way around it, i don't know it.

Regards
FSt1

"jswalsh33" wrote:

You answered the real question, which was can the macros and the workbook be
separated.

What I was trying to do was to save changes in the workbook and not save
changes in the macros.

Any ideas on that one?

Thanks,

Jim Walsh


"FSt1" wrote:

hi
you seem to have two questions.
subject:Separate macro from workbook.
no. can't be done.
not sure about your second question. if it's in the xls start folder, it
will open with excel and all macros in the open workbooks can be use on other
files provided they are generic ie make no reference to a specific workbook
name or worksheet name.

if i didn't answer your question, post back with more detail.

Regards
FSt1

"jswalsh33" wrote:

In response to a question on allowing a macro to be available for all files
in Excel dated 5/17/09, FST1 wrote a solution that did what was requested.

Namely:
C:\Program Files\Microsoft Office\Office12\XLSTART (i think).
The file will open automaticly(hidden) when excel starts and all macros in
the personal.xlsb will be available for use on all files.

My question is can the same be done for certain Excel workbooks but not
others?

Any help will be greatly appreciated.

Jim Walsh

Been following this and not sure what OP is after.

First talks about Personal Macro Workbook being in XLSTART folder and
opening hidden, then asks "can the same be done for certain Excel workbooks
but not others?"

Does OP want to have more workbooks in XLSTART folder that open hidden?

Yes is the answer to that.

Does OP want some macros available for some workbooks but not have
Personal.xls open all the time.

Also Yes to that.

Can you have macros in a workbook and save the workbook and delete the
macros when saving.

Yes to that also.

OP needs to describe needs in more detail.


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 12:04:01 -0700, FSt1
wrote:

hi
no really. the vb part and the file are intergrated. saving saves all. if
there is a way around it, i don't know it.

Regards
FSt1

"jswalsh33" wrote:

You answered the real question, which was can the macros and the workbook be
separated.

What I was trying to do was to save changes in the workbook and not save
changes in the macros.

Any ideas on that one?

Thanks,

Jim Walsh


"FSt1" wrote:

hi
you seem to have two questions.
subject:Separate macro from workbook.
no. can't be done.
not sure about your second question. if it's in the xls start folder, it
will open with excel and all macros in the open workbooks can be use on other
files provided they are generic ie make no reference to a specific workbook
name or worksheet name.

if i didn't answer your question, post back with more detail.

Regards
FSt1

"jswalsh33" wrote:

In response to a question on allowing a macro to be available for all files
in Excel dated 5/17/09, FST1 wrote a solution that did what was requested.

Namely:
C:\Program Files\Microsoft Office\Office12\XLSTART (i think).
The file will open automaticly(hidden) when excel starts and all macros in
the personal.xlsb will be available for use on all files.

My question is can the same be done for certain Excel workbooks but not
others?

Any help will be greatly appreciated.

Jim Walsh

Gord,

Thanks for your interest.

I have a workbook with a large number of macros.

The workbook contains three databases. Different users use copies of the
workbook and have different data in the databases.

The Macro's may be changed from time to time by a control person and should
apply to all users workbooks.

Therefore, I would like to have a common set of macros apply to the
workbooks of each user as the workbooks are opened.

Your response of deleting Macro's when the workbook is closed would seem to
apply if I could then reestablish the common macro set when reopening any of
the workbooks.

Please give me a clue on that one and I will try it.

Thanks,

Jim Walsh

"Gord Dibben" wrote:

Been following this and not sure what OP is after.

First talks about Personal Macro Workbook being in XLSTART folder and
opening hidden, then asks "can the same be done for certain Excel workbooks
but not others?"

Does OP want to have more workbooks in XLSTART folder that open hidden?

Yes is the answer to that.

Does OP want some macros available for some workbooks but not have
Personal.xls open all the time.

Also Yes to that.

Can you have macros in a workbook and save the workbook and delete the
macros when saving.

Yes to that also.

OP needs to describe needs in more detail.


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 12:04:01 -0700, FSt1
wrote:

hi
no really. the vb part and the file are intergrated. saving saves all. if
there is a way around it, i don't know it.

Regards
FSt1

"jswalsh33" wrote:

You answered the real question, which was can the macros and the workbook be
separated.

What I was trying to do was to save changes in the workbook and not save
changes in the macros.

Any ideas on that one?

Thanks,

Jim Walsh


"FSt1" wrote:

hi
you seem to have two questions.
subject:Separate macro from workbook.
no. can't be done.
not sure about your second question. if it's in the xls start folder, it
will open with excel and all macros in the open workbooks can be use on other
files provided they are generic ie make no reference to a specific workbook
name or worksheet name.

if i didn't answer your question, post back with more detail.

Regards
FSt1

"jswalsh33" wrote:

In response to a question on allowing a macro to be available for all files
in Excel dated 5/17/09, FST1 wrote a solution that did what was requested.

Namely:
C:\Program Files\Microsoft Office\Office12\XLSTART (i think).
The file will open automaticly(hidden) when excel starts and all macros in
the personal.xlsb will be available for use on all files.

My question is can the same be done for certain Excel workbooks but not
others?

Any help will be greatly appreciated.

Jim Walsh

.