Initiating the VBA program

D

Dino

Hi, this is a very basic question: I found a VBA program here that I think
might help solve my problem, but once I copy and paste the code into the code
window, how do I make the program run? When I create a macro, I give the
macro a keystroke combination to run, but when I create/copy a VBA program I
don't know how to start the code running once I get back to the spreadsheet.

Thanks to anyone who can help,
Dino
 
D

Dino

I pasted the code into the "VBAProject (Book1) / ThisWorkbook" code window. I
did notice that I also have a "VBAProject (Personal.xlsb) / ThisWorkbook
window also available. I want this and future programs to be available on my
copy of Excel 2007 regardless of which workbook I'm in.
 
K

Kenneth Hobson

In the Project explorer, right click and Insert a Module. Only your
macros from a Module will be in the Alt+F8 picks. Be sure to insert the
module into your Personal workbook if you want to use it for other
workbooks.
 
Top