| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in 2007
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
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 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
Did you remember to reassign the newly renamed macro to the icon on the QAT?
Did you make sure that you point to the personal.xls workbook? I'd read Ron de Bruin's tips to see if he has any suggestions: http://www.rondebruin.nl/qat.htm Winnipeg Michael wrote: 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 -- Dave Peterson |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros in 2007
Yes, and I'm pretty sure yes.
Its something that I am probably missing, that when it is figured out, I'll go, "oh, yeah, riiiiiiiiiiiight." Thanks for the link. I'll give that a good looksie Thanks, "Dave Peterson" wrote: Did you remember to reassign the newly renamed macro to the icon on the QAT? Did you make sure that you point to the personal.xls workbook? I'd read Ron de Bruin's tips to see if he has any suggestions: http://www.rondebruin.nl/qat.htm Winnipeg Michael wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question on Macros in 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
| Excel 2007 and Macros | Excel Discussion (Misc queries) | |||
| Macros in Excel 2007 | Excel Discussion (Misc queries) | |||
| Enable macros in 2007 | Excel Discussion (Misc queries) | |||
Linear Mode
