If I record a macro and save it in Personal macros, will it still work if I
email the file to another person? I am going to make it that the macro works
when they click a picture on the worksheet itself.

What if I save the macro in that file and email it to someone....they will
be changing the name of the file, will that disable the macro?

Personal.xls means just that. So, unless you also send that file (which they
may not appreciate) then I suggest you put the macro in the file it works
on. As to the name change, it depends. Post your macro.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"carrera" wrote in message
...
If I record a macro and save it in Personal macros, will it still work if
I
email the file to another person? I am going to make it that the macro
works
when they click a picture on the worksheet itself.

What if I save the macro in that file and email it to someone....they will
be changing the name of the file, will that disable the macro?

Record the macro in the workbook, not Personal.xls or you would have to send
that also.

Unless you have a hard-coded workbook name and/or path in your macro, it should
work on other person's computer.


Gord Dibben MS Excel MVP

On Tue, 21 Aug 2007 14:36:00 -0700, carrera
wrote:

If I record a macro and save it in Personal macros, will it still work if I
email the file to another person? I am going to make it that the macro works
when they click a picture on the worksheet itself.

What if I save the macro in that file and email it to someone....they will
be changing the name of the file, will that disable the macro?

Like Don and Gord suggested, you could put the macro in the workbook that
contains the data.

But (just a suggestion), if this macro is pretty generic and will (or could) be
used in lots of workbooks, you could create a CarreraUtils.xls workbook that
contains just the code--no data at all.

Then if the code needs to get updated (it will someday!), you just update the
CarreraUtils.xls file and send it out. You don't have to worry about having
100's of workbooks with the old code that's out of date.

And when you get lots of macros you want to share with others, you'll want to
give them a way to access them--besides Tools|Macro|macros.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)


carrera wrote:

If I record a macro and save it in Personal macros, will it still work if I
email the file to another person? I am going to make it that the macro works
when they click a picture on the worksheet itself.

What if I save the macro in that file and email it to someone....they will
be changing the name of the file, will that disable the macro?

--

Dave Peterson

And just to add to both Don and Gord's reply (again).

The reason you don't want to call the workbook you share with others
"personal.xls" is that if those users have any macros, they could have used that
name.

And excel will only allow one workbook with that name open at any one time. You
wouldn't want them to have to make a choice--or irritate them by having to close
their workbook before they could open yours.

carrera wrote:

If I record a macro and save it in Personal macros, will it still work if I
email the file to another person? I am going to make it that the macro works
when they click a picture on the worksheet itself.

What if I save the macro in that file and email it to someone....they will
be changing the name of the file, will that disable the macro?

--

Dave Peterson

Thanks for all your answers, but most of it was over my head.

I don't know how to write a macro, I just record them.

In this case, I'll have a password protected workbook, and the macro will
delete the contents of the unlocked cells, as the users will be using it as a
form, which they send to me weekly.

I have no control over their renaming the file.

The people who will be filling in the unlocked cells do not often sit down
at a computer, and I'm trying to make it as easy for them as possible.

From what I'm getting here, I should save the macro to just that workbook?



"Dave Peterson" wrote:

And just to add to both Don and Gord's reply (again).

The reason you don't want to call the workbook you share with others
"personal.xls" is that if those users have any macros, they could have used that
name.

And excel will only allow one workbook with that name open at any one time. You
wouldn't want them to have to make a choice--or irritate them by having to close
their workbook before they could open yours.

carrera wrote:

If I record a macro and save it in Personal macros, will it still work if I
email the file to another person? I am going to make it that the macro works
when they click a picture on the worksheet itself.

What if I save the macro in that file and email it to someone....they will
be changing the name of the file, will that disable the macro?

--

Dave Peterson

See in-line........

On Wed, 22 Aug 2007 07:10:01 -0700, carrera
wrote:

Thanks for all your answers, but most of it was over my head.

I don't know how to write a macro, I just record them.

When recording you have the choice of which workbook to record
to..............This Workbook or Personal Macro Workbook or New Workbook


In this case, I'll have a password protected workbook, and the macro will
delete the contents of the unlocked cells, as the users will be using it as a
form, which they send to me weekly.

Note: protecting the workbook will not lock cells.

You must protect the worksheet with the cells in question formatted as
"unlocked"

I have no control over their renaming the file.

Should not matter if they change the name if it is not hard-coded in the macro.

The people who will be filling in the unlocked cells do not often sit down
at a computer, and I'm trying to make it as easy for them as possible.

From what I'm getting here, I should save the macro to just that workbook?

I would say yes.


Gord


"Dave Peterson" wrote:

And just to add to both Don and Gord's reply (again).

The reason you don't want to call the workbook you share with others
"personal.xls" is that if those users have any macros, they could have used that
name.

And excel will only allow one workbook with that name open at any one time. You
wouldn't want them to have to make a choice--or irritate them by having to close
their workbook before they could open yours.

carrera wrote:

If I record a macro and save it in Personal macros, will it still work if I
email the file to another person? I am going to make it that the macro works
when they click a picture on the worksheet itself.

What if I save the macro in that file and email it to someone....they will
be changing the name of the file, will that disable the macro?

--

Dave Peterson

As I explained in my last response, I'm not knowledgeable with writing code
for macros....so I don't know what you mean by a "hard coded" file name.

I understand you are an MVP and quite knowledgeable, but it doesn't really
help to say "See in-line....." when part of what you said is not something
I'm familiar with.

I feel my last question was slightly different from my first, as far as the
people I will be sending this to changing the name.

I don't feel it would take that much more of your time to answer that
specifically, rather than referring me back to an answer I didn't fully
understand.
Thanks in Advance for answering the question I just asked...

"Gord Dibben" wrote:

See in-line........

On Wed, 22 Aug 2007 07:10:01 -0700, carrera
wrote:

Thanks for all your answers, but most of it was over my head.

I don't know how to write a macro, I just record them.

When recording you have the choice of which workbook to record
to..............This Workbook or Personal Macro Workbook or New Workbook


In this case, I'll have a password protected workbook, and the macro will
delete the contents of the unlocked cells, as the users will be using it as a
form, which they send to me weekly.

Note: protecting the workbook will not lock cells.

You must protect the worksheet with the cells in question formatted as
"unlocked"

I have no control over their renaming the file.

Should not matter if they change the name if it is not hard-coded in the macro.

The people who will be filling in the unlocked cells do not often sit down
at a computer, and I'm trying to make it as easy for them as possible.

From what I'm getting here, I should save the macro to just that workbook?

I would say yes.


Gord


"Dave Peterson" wrote:

And just to add to both Don and Gord's reply (again).

The reason you don't want to call the workbook you share with others
"personal.xls" is that if those users have any macros, they could have used that
name.

And excel will only allow one workbook with that name open at any one time. You
wouldn't want them to have to make a choice--or irritate them by having to close
their workbook before they could open yours.

carrera wrote:

If I record a macro and save it in Personal macros, will it still work if I
email the file to another person? I am going to make it that the macro works
when they click a picture on the worksheet itself.

What if I save the macro in that file and email it to someone....they will
be changing the name of the file, will that disable the macro?

--

Dave Peterson

We are all volunteers here and your comments about the quality and methods of my
attempts to assist show a bit of impatience on your part.

My time is mine and how I allocate it is up to me.

Got that off my chest.............now to answer.

When you click on ToolsMacroRecord New Macro a dialog will open.

In that dialog is a "Store Macro In"

Select This Workbook then record the macro.

Send the workbook to your users.

They can change the name and your macro(s) will still work.

"hard-coded" means a reference in your macro to a specific filename or sheetname
which could get changed.

In that case, the macro would error out.


Gord



On Wed, 22 Aug 2007 07:54:04 -0700, carrera
wrote:

As I explained in my last response, I'm not knowledgeable with writing code
for macros....so I don't know what you mean by a "hard coded" file name.

I understand you are an MVP and quite knowledgeable, but it doesn't really
help to say "See in-line....." when part of what you said is not something
I'm familiar with.

I feel my last question was slightly different from my first, as far as the
people I will be sending this to changing the name.

I don't feel it would take that much more of your time to answer that
specifically, rather than referring me back to an answer I didn't fully
understand.
Thanks in Advance for answering the question I just asked...

"Gord Dibben" wrote:

See in-line........

On Wed, 22 Aug 2007 07:10:01 -0700, carrera
wrote:

Thanks for all your answers, but most of it was over my head.

I don't know how to write a macro, I just record them.

When recording you have the choice of which workbook to record
to..............This Workbook or Personal Macro Workbook or New Workbook


In this case, I'll have a password protected workbook, and the macro will
delete the contents of the unlocked cells, as the users will be using it as a
form, which they send to me weekly.

Note: protecting the workbook will not lock cells.

You must protect the worksheet with the cells in question formatted as
"unlocked"

I have no control over their renaming the file.

Should not matter if they change the name if it is not hard-coded in the macro.

The people who will be filling in the unlocked cells do not often sit down
at a computer, and I'm trying to make it as easy for them as possible.

From what I'm getting here, I should save the macro to just that workbook?

I would say yes.


Gord


"Dave Peterson" wrote:

And just to add to both Don and Gord's reply (again).

The reason you don't want to call the workbook you share with others
"personal.xls" is that if those users have any macros, they could have used that
name.

And excel will only allow one workbook with that name open at any one time. You
wouldn't want them to have to make a choice--or irritate them by having to close
their workbook before they could open yours.

carrera wrote:

If I record a macro and save it in Personal macros, will it still work if I
email the file to another person? I am going to make it that the macro works
when they click a picture on the worksheet itself.

What if I save the macro in that file and email it to someone....they will
be changing the name of the file, will that disable the macro?

--

Dave Peterson