View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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.