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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Data to non-office program 2
vba powerpoint pasting named shape in selected named slides 0
Word VBA for deleting Selected Row 0
CommonButton was out of function since Dec 2014 6
VBA copy and paste data 2
VBA to run all variable combinations in a calculation model and store result 6
copying down the formula just for data 3
vba in excel 2007 5

Top