Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a macro so when I click the icon, the response is the A1 ce
I want to create a macro in Excel 2007, so when I click the icon that I
create, the macro runs and goes to the A1 cell. I had this macro for Excel 2003, which starts in a Personal.xls sheet, and works in any spreadsheet that I open up. I am trying to do the same in Excel 2007, and having a great deal of difficulty in doing so. I will probably need start to finish instructions for this, or a link of some sort where it does this in detail. I've spent almost a day in trying to do this. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a macro so when I click the icon, the response is the A1 ce
See
http://www.rondebruin.nl/personal.htm Code looks like this Application.Goto Range("A1"), True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I want to create a macro in Excel 2007, so when I click the icon that I create, the macro runs and goes to the A1 cell. I had this macro for Excel 2003, which starts in a Personal.xls sheet, and works in any spreadsheet that I open up. I am trying to do the same in Excel 2007, and having a great deal of difficulty in doing so. I will probably need start to finish instructions for this, or a link of some sort where it does this in detail. I've spent almost a day in trying to do this. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a macro so when I click the icon, the response is the A
Hi Ron.
I was sent this on an earlier post, but for some reason, I am unable to achieve the results that I am looking for. I think I need to start all over again, and read your attachment right from start to finish. Thanks for your reply, Michael "Ron de Bruin" wrote: See http://www.rondebruin.nl/personal.htm Code looks like this Application.Goto Range("A1"), True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I want to create a macro in Excel 2007, so when I click the icon that I create, the macro runs and goes to the A1 cell. I had this macro for Excel 2003, which starts in a Personal.xls sheet, and works in any spreadsheet that I open up. I am trying to do the same in Excel 2007, and having a great deal of difficulty in doing so. I will probably need start to finish instructions for this, or a link of some sort where it does this in detail. I've spent almost a day in trying to do this. Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a macro so when I click the icon, the response is the A
Nope, its worse.
"Winnipeg Michael" wrote: Hi Ron. I was sent this on an earlier post, but for some reason, I am unable to achieve the results that I am looking for. I think I need to start all over again, and read your attachment right from start to finish. Thanks for your reply, Michael "Ron de Bruin" wrote: See http://www.rondebruin.nl/personal.htm Code looks like this Application.Goto Range("A1"), True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I want to create a macro in Excel 2007, so when I click the icon that I create, the macro runs and goes to the A1 cell. I had this macro for Excel 2003, which starts in a Personal.xls sheet, and works in any spreadsheet that I open up. I am trying to do the same in Excel 2007, and having a great deal of difficulty in doing so. I will probably need start to finish instructions for this, or a link of some sort where it does this in detail. I've spent almost a day in trying to do this. Thank you. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a macro so when I click the icon, the response is the A
When you open the VBA edito with Alt F11
Do you see your personal file ? Is it named personal.xls ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... Nope, its worse. "Winnipeg Michael" wrote: Hi Ron. I was sent this on an earlier post, but for some reason, I am unable to achieve the results that I am looking for. I think I need to start all over again, and read your attachment right from start to finish. Thanks for your reply, Michael "Ron de Bruin" wrote: See http://www.rondebruin.nl/personal.htm Code looks like this Application.Goto Range("A1"), True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I want to create a macro in Excel 2007, so when I click the icon that I create, the macro runs and goes to the A1 cell. I had this macro for Excel 2003, which starts in a Personal.xls sheet, and works in any spreadsheet that I open up. I am trying to do the same in Excel 2007, and having a great deal of difficulty in doing so. I will probably need start to finish instructions for this, or a link of some sort where it does this in detail. I've spent almost a day in trying to do this. Thank you. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a macro so when I click the icon, the response is the A
I saw it, but it got all messed up with the Book1 spreadsheet that I started
with (which was wrong, I realize that now). To properly start, I should open Excel, and save as Personal.xlsb in my XLSTART folder, right? "Ron de Bruin" wrote: When you open the VBA edito with Alt F11 Do you see your personal file ? Is it named personal.xls ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... Nope, its worse. "Winnipeg Michael" wrote: Hi Ron. I was sent this on an earlier post, but for some reason, I am unable to achieve the results that I am looking for. I think I need to start all over again, and read your attachment right from start to finish. Thanks for your reply, Michael "Ron de Bruin" wrote: See http://www.rondebruin.nl/personal.htm Code looks like this Application.Goto Range("A1"), True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I want to create a macro in Excel 2007, so when I click the icon that I create, the macro runs and goes to the A1 cell. I had this macro for Excel 2003, which starts in a Personal.xls sheet, and works in any spreadsheet that I open up. I am trying to do the same in Excel 2007, and having a great deal of difficulty in doing so. I will probably need start to finish instructions for this, or a link of some sort where it does this in detail. I've spent almost a day in trying to do this. Thank you. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a macro so when I click the icon, the response is the A
Close Excel
Remove the personal file out your Xlstart folder And create a new one with the info from my page or add your old personal file from 2003 in xlstart -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I saw it, but it got all messed up with the Book1 spreadsheet that I started with (which was wrong, I realize that now). To properly start, I should open Excel, and save as Personal.xlsb in my XLSTART folder, right? "Ron de Bruin" wrote: When you open the VBA edito with Alt F11 Do you see your personal file ? Is it named personal.xls ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... Nope, its worse. "Winnipeg Michael" wrote: Hi Ron. I was sent this on an earlier post, but for some reason, I am unable to achieve the results that I am looking for. I think I need to start all over again, and read your attachment right from start to finish. Thanks for your reply, Michael "Ron de Bruin" wrote: See http://www.rondebruin.nl/personal.htm Code looks like this Application.Goto Range("A1"), True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I want to create a macro in Excel 2007, so when I click the icon that I create, the macro runs and goes to the A1 cell. I had this macro for Excel 2003, which starts in a Personal.xls sheet, and works in any spreadsheet that I open up. I am trying to do the same in Excel 2007, and having a great deal of difficulty in doing so. I will probably need start to finish instructions for this, or a link of some sort where it does this in detail. I've spent almost a day in trying to do this. Thank you. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a macro so when I click the icon, the response is the A
I did clear it out.
The old one was "lost" with the new software upgrade. This is what is compounding my problem. I thought I was smart enough to know Excel, but I guess not. "Ron de Bruin" wrote: Close Excel Remove the personal file out your Xlstart folder And create a new one with the info from my page or add your old personal file from 2003 in xlstart -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I saw it, but it got all messed up with the Book1 spreadsheet that I started with (which was wrong, I realize that now). To properly start, I should open Excel, and save as Personal.xlsb in my XLSTART folder, right? "Ron de Bruin" wrote: When you open the VBA edito with Alt F11 Do you see your personal file ? Is it named personal.xls ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... Nope, its worse. "Winnipeg Michael" wrote: Hi Ron. I was sent this on an earlier post, but for some reason, I am unable to achieve the results that I am looking for. I think I need to start all over again, and read your attachment right from start to finish. Thanks for your reply, Michael "Ron de Bruin" wrote: See http://www.rondebruin.nl/personal.htm Code looks like this Application.Goto Range("A1"), True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I want to create a macro in Excel 2007, so when I click the icon that I create, the macro runs and goes to the A1 cell. I had this macro for Excel 2003, which starts in a Personal.xls sheet, and works in any spreadsheet that I open up. I am trying to do the same in Excel 2007, and having a great deal of difficulty in doing so. I will probably need start to finish instructions for this, or a link of some sort where it does this in detail. I've spent almost a day in trying to do this. Thank you. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a macro so when I click the icon, the response is the A
Do I need to do the dummy macro?
When I have Personal.xlsb created, can I start on creating the macro? "Ron de Bruin" wrote: Close Excel Remove the personal file out your Xlstart folder And create a new one with the info from my page or add your old personal file from 2003 in xlstart -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I saw it, but it got all messed up with the Book1 spreadsheet that I started with (which was wrong, I realize that now). To properly start, I should open Excel, and save as Personal.xlsb in my XLSTART folder, right? "Ron de Bruin" wrote: When you open the VBA edito with Alt F11 Do you see your personal file ? Is it named personal.xls ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... Nope, its worse. "Winnipeg Michael" wrote: Hi Ron. I was sent this on an earlier post, but for some reason, I am unable to achieve the results that I am looking for. I think I need to start all over again, and read your attachment right from start to finish. Thanks for your reply, Michael "Ron de Bruin" wrote: See http://www.rondebruin.nl/personal.htm Code looks like this Application.Goto Range("A1"), True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I want to create a macro in Excel 2007, so when I click the icon that I create, the macro runs and goes to the A1 cell. I had this macro for Excel 2003, which starts in a Personal.xls sheet, and works in any spreadsheet that I open up. I am trying to do the same in Excel 2007, and having a great deal of difficulty in doing so. I will probably need start to finish instructions for this, or a link of some sort where it does this in detail. I've spent almost a day in trying to do this. Thank you. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a macro so when I click the icon, the response is the A
If you create the file yourself be sure it is hidden.
Copy the macro in the file and you can run it with alt-F8 Maybe you like this add-in for Excel 2007 http://www.rondebruin.nl/qat.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... Do I need to do the dummy macro? When I have Personal.xlsb created, can I start on creating the macro? "Ron de Bruin" wrote: Close Excel Remove the personal file out your Xlstart folder And create a new one with the info from my page or add your old personal file from 2003 in xlstart -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I saw it, but it got all messed up with the Book1 spreadsheet that I started with (which was wrong, I realize that now). To properly start, I should open Excel, and save as Personal.xlsb in my XLSTART folder, right? "Ron de Bruin" wrote: When you open the VBA edito with Alt F11 Do you see your personal file ? Is it named personal.xls ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... Nope, its worse. "Winnipeg Michael" wrote: Hi Ron. I was sent this on an earlier post, but for some reason, I am unable to achieve the results that I am looking for. I think I need to start all over again, and read your attachment right from start to finish. Thanks for your reply, Michael "Ron de Bruin" wrote: See http://www.rondebruin.nl/personal.htm Code looks like this Application.Goto Range("A1"), True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I want to create a macro in Excel 2007, so when I click the icon that I create, the macro runs and goes to the A1 cell. I had this macro for Excel 2003, which starts in a Personal.xls sheet, and works in any spreadsheet that I open up. I am trying to do the same in Excel 2007, and having a great deal of difficulty in doing so. I will probably need start to finish instructions for this, or a link of some sort where it does this in detail. I've spent almost a day in trying to do this. Thank you. |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a macro so when I click the icon, the response is the A
Thanks for your help Ron.
I did find this: http://www.mvps.org/dmcritchie/excel/getstarted.htm and it made it clearer to perform the macros I wanted. But thanks for your help. "Ron de Bruin" wrote: If you create the file yourself be sure it is hidden. Copy the macro in the file and you can run it with alt-F8 Maybe you like this add-in for Excel 2007 http://www.rondebruin.nl/qat.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... Do I need to do the dummy macro? When I have Personal.xlsb created, can I start on creating the macro? "Ron de Bruin" wrote: Close Excel Remove the personal file out your Xlstart folder And create a new one with the info from my page or add your old personal file from 2003 in xlstart -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I saw it, but it got all messed up with the Book1 spreadsheet that I started with (which was wrong, I realize that now). To properly start, I should open Excel, and save as Personal.xlsb in my XLSTART folder, right? "Ron de Bruin" wrote: When you open the VBA edito with Alt F11 Do you see your personal file ? Is it named personal.xls ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... Nope, its worse. "Winnipeg Michael" wrote: Hi Ron. I was sent this on an earlier post, but for some reason, I am unable to achieve the results that I am looking for. I think I need to start all over again, and read your attachment right from start to finish. Thanks for your reply, Michael "Ron de Bruin" wrote: See http://www.rondebruin.nl/personal.htm Code looks like this Application.Goto Range("A1"), True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Winnipeg Michael" wrote in message ... I want to create a macro in Excel 2007, so when I click the icon that I create, the macro runs and goes to the A1 cell. I had this macro for Excel 2003, which starts in a Personal.xls sheet, and works in any spreadsheet that I open up. I am trying to do the same in Excel 2007, and having a great deal of difficulty in doing so. I will probably need start to finish instructions for this, or a link of some sort where it does this in detail. I've spent almost a day in trying to do this. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double click on icon opens Excel but does not open file | Excel Discussion (Misc queries) | |||
create automatic response to questions in excel.... | New Users to Excel | |||
Opening a worksheet when you click on the desktop icon. | Excel Discussion (Misc queries) | |||
Little problem, when click open icon | Excel Discussion (Misc queries) | |||
Excel 2000...Click on different Worksheet...Get a New icon and can | Excel Discussion (Misc queries) |