I had a spreadsheet in 2003, called PERSONAL.xls. In it, was two macros,
that sent me to specific cells. Each time I opened up an .xls, the
PERSONAL.xls would open, then the spreadsheet I wanted would follow. The
macros would be enabled without any problems.
How can I have this happen again in Excel 2007? I'm having problems trying
to perform this same action again.

Thank you.

Is 2007 opening that Personal.xls?

--
__________________________________
HTH

Bob

"Winnipeg Michael" wrote in
message ...
I had a spreadsheet in 2003, called PERSONAL.xls. In it, was two macros,
that sent me to specific cells. Each time I opened up an .xls, the
PERSONAL.xls would open, then the spreadsheet I wanted would follow. The
macros would be enabled without any problems.
How can I have this happen again in Excel 2007? I'm having problems
trying
to perform this same action again.

Thank you.

You should be able to copy that personal.xls and put it into xl2007's XLStart
folder. And then the behavior should be the same.

Did you try that? And what happened when you did?

Winnipeg Michael wrote:

I had a spreadsheet in 2003, called PERSONAL.xls. In it, was two macros,
that sent me to specific cells. Each time I opened up an .xls, the
PERSONAL.xls would open, then the spreadsheet I wanted would follow. The
macros would be enabled without any problems.
How can I have this happen again in Excel 2007? I'm having problems trying
to perform this same action again.

Thank you.

--

Dave Peterson

Yes, tried it, but I receive this error:
Cannot run the macro "A1". The macro may not be available in this workbook,
or all macros may be disabled.

Soooooo, I have to disable them?



"Dave Peterson" wrote:

You should be able to copy that personal.xls and put it into xl2007's XLStart
folder. And then the behavior should be the same.

Did you try that? And what happened when you did?

Winnipeg Michael wrote:

I had a spreadsheet in 2003, called PERSONAL.xls. In it, was two macros,
that sent me to specific cells. Each time I opened up an .xls, the
PERSONAL.xls would open, then the spreadsheet I wanted would follow. The
macros would be enabled without any problems.
How can I have this happen again in Excel 2007? I'm having problems trying
to perform this same action again.

Thank you.

--

Dave Peterson

Do you have a macro named A1 in that workbook?

If you do, you'll want to enable those macros.

Did you get prompted when you opened the personal.xls workbook to enable the
macro--you may have seen a horizontal prompt just above the worksheet area and
formulabar, but below the ribbon.

(I use a personal.xla (addin file) in xl2007) and it's placed in my XLStart
folder. I don't get prompted to enable the macros.)

You may want to check your security settings, too.
It's under:
Office Button}|Excel Options|Trust Center


Winnipeg Michael wrote:

Yes, tried it, but I receive this error:
Cannot run the macro "A1". The macro may not be available in this workbook,
or all macros may be disabled.

Soooooo, I have to disable them?

"Dave Peterson" wrote:

You should be able to copy that personal.xls and put it into xl2007's XLStart
folder. And then the behavior should be the same.

Did you try that? And what happened when you did?

Winnipeg Michael wrote:

I had a spreadsheet in 2003, called PERSONAL.xls. In it, was two macros,
that sent me to specific cells. Each time I opened up an .xls, the
PERSONAL.xls would open, then the spreadsheet I wanted would follow. The
macros would be enabled without any problems.
How can I have this happen again in Excel 2007? I'm having problems trying
to perform this same action again.

Thank you.

--

Dave Peterson


--

Dave Peterson

I have two macros. The first one, goes to the A1 cell. The second one goes
to the AF60 cell. They both work in the Personal.xls spreadsheet. When I
open up a second Excel spreadsheet, the macros dont work (the error message
as noted below).

There was no prompt when I open the Personal.xls. When I open up a
different Excel spreadsheet, the Personal.xls opens up (as it should), then
the spreadsheet I want to work on opens (as it should), but there is no
prompt from either spreadsheets.

What would the preffered security settings be, so that these two macros work?

Thanks for your help.




"Dave Peterson" wrote:

Do you have a macro named A1 in that workbook?

If you do, you'll want to enable those macros.

Did you get prompted when you opened the personal.xls workbook to enable the
macro--you may have seen a horizontal prompt just above the worksheet area and
formulabar, but below the ribbon.

(I use a personal.xla (addin file) in xl2007) and it's placed in my XLStart
folder. I don't get prompted to enable the macros.)

You may want to check your security settings, too.
It's under:
Office Button}|Excel Options|Trust Center


Winnipeg Michael wrote:

Yes, tried it, but I receive this error:
Cannot run the macro "A1". The macro may not be available in this workbook,
or all macros may be disabled.

Soooooo, I have to disable them?

"Dave Peterson" wrote:

You should be able to copy that personal.xls and put it into xl2007's XLStart
folder. And then the behavior should be the same.

Did you try that? And what happened when you did?

Winnipeg Michael wrote:

I had a spreadsheet in 2003, called PERSONAL.xls. In it, was two macros,
that sent me to specific cells. Each time I opened up an .xls, the
PERSONAL.xls would open, then the spreadsheet I wanted would follow. The
macros would be enabled without any problems.
How can I have this happen again in Excel 2007? I'm having problems trying
to perform this same action again.

Thank you.

--

Dave Peterson


--

Dave Peterson

How do you run the macros?

If you change the name to something that doesn't look like cell addresses
(GOTO_A1 and GOTO_AF60), do they work?

I don't think it's any setting that you have to change.

Winnipeg Michael wrote:

I have two macros. The first one, goes to the A1 cell. The second one goes
to the AF60 cell. They both work in the Personal.xls spreadsheet. When I
open up a second Excel spreadsheet, the macros dont work (the error message
as noted below).

There was no prompt when I open the Personal.xls. When I open up a
different Excel spreadsheet, the Personal.xls opens up (as it should), then
the spreadsheet I want to work on opens (as it should), but there is no
prompt from either spreadsheets.

What would the preffered security settings be, so that these two macros work?

Thanks for your help.

"Dave Peterson" wrote:

Do you have a macro named A1 in that workbook?

If you do, you'll want to enable those macros.

Did you get prompted when you opened the personal.xls workbook to enable the
macro--you may have seen a horizontal prompt just above the worksheet area and
formulabar, but below the ribbon.

(I use a personal.xla (addin file) in xl2007) and it's placed in my XLStart
folder. I don't get prompted to enable the macros.)

You may want to check your security settings, too.
It's under:
Office Button}|Excel Options|Trust Center


Winnipeg Michael wrote:

Yes, tried it, but I receive this error:
Cannot run the macro "A1". The macro may not be available in this workbook,
or all macros may be disabled.

Soooooo, I have to disable them?

"Dave Peterson" wrote:

You should be able to copy that personal.xls and put it into xl2007's XLStart
folder. And then the behavior should be the same.

Did you try that? And what happened when you did?

Winnipeg Michael wrote:

I had a spreadsheet in 2003, called PERSONAL.xls. In it, was two macros,
that sent me to specific cells. Each time I opened up an .xls, the
PERSONAL.xls would open, then the spreadsheet I wanted would follow. The
macros would be enabled without any problems.
How can I have this happen again in Excel 2007? I'm having problems trying
to perform this same action again.

Thank you.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson