Gotchya.

I created a button/icon for each of the macros. I put the button on the
Quick Access Toolbar.

I did re-do the macro, as per your suggestion. it works for the
Personal.xls, but not for any other .xls sheets that I open.



"Dave Peterson" wrote:

Do you have a button on the worksheet, do you have a toolbar, do you run it via
the tools|macro dialog (alt-f8) or what?



Winnipeg Michael wrote:

Oh, okay. I get it.

I'll try that.

As for, "how do I run the macros?". I'm not sure what you are asking. I
created the macros, and the macros are to run in all open workbooks.

"Dave Peterson" wrote:

Nope. I'm suggesting that you try changing the name of the macro:

Sub GOTO_AF60()
Range("AF60").Select
End Sub

And you didn't answer this question:

How do you run the macros?


Winnipeg Michael wrote:

As an example, here is the AF60 macro:

Sub AF60()
Range("AF60").Select
End Sub

They worked before, as shown. Are you suggesting to use the GOTO instead?

Thanks!

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson