| 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. |
| 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) | |||
Hybrid Mode
