I will regularly be downloading new Excel spreadsheets to my desktop
but will need to run the same macro (that i have recently created) o
each file.

What I'm thinking is that I will create a file on my desktop that ha
the macro saved there, plus a button on Sheet 1 that will allow th
user (sometimes a coworker who doesn't understand this stuff) to jus
go get the downloaded file and pull it into that doc. Then, the use
could use the keyboard shortcut to run the macro.

Any suggestions on how to create this button and the underlying VB t
get the user to the "Open file" area?

Thanks

--
Message posted from http://www.ExcelForum.com