Basic Beginners Query

Mar 8th, 2002, 11:14 AM

After copying a macro and then pasting it into the visual basic editor, how do i then save it so that when i go to macros and attempt to run it it appears.?

Sorry for being very dense!

Barrie Davidson · Mar 8th, 2002, 11:25 AM

Quote:

On 2002-03-08 10:14, Anonymous wrote:

After copying a macro and then pasting it into the visual basic editor, how do i then save it so that when i go to macros and attempt to run it it appears.?

Sorry for being very dense!

No need to apologize, we've all been there. After copying your macro you need to select the workbook where you want to keep you macro. In your Project Explorer window (usually the top left window with the title - "Project - VBA Project") highlight the workbook where you want to keep your macro. Then, from the main menu, select Insert|Module. Your window on the right hand side will then have a blank module, and you'll notice that you have a module folder under your file in the Project Explorer window. Paste your macro in the module window and then save your file (File|Save).

Is this explanation sufficient?

Mar 8th, 2002, 11:42 AM

should i then be able to open this thro' tools>macro>macros, because that's what i want to do but still don't seem to be having any luck?!

Barrie Davidson · Mar 8th, 2002, 11:49 AM

Quote:

On 2002-03-08 10:42, Anonymous wrote:
should i then be able to open this thro' tools>macro>macros, because that's what i want to do but still don't seem to be having any luck?!

Yes. If you need any further help just let me know.

Mar 8th, 2002, 11:58 AM

Sorry Barrie, still no joy - after selecting the workbook (VBAProject newtest.xls), i then inserted the module and pasted my macro.
Then saved - file>save newtest.xls, it appeared to save, but i still can't find the macro when i want to select it as discussed above.

Barrie Davidson · Mar 8th, 2002, 12:00 PM

Quote:

On 2002-03-08 10:58, Anonymous wrote:
Sorry Barrie, still no joy - after selecting the workbook (VBAProject newtest.xls), i then inserted the module and pasted my macro.
Then saved - file>save newtest.xls, it appeared to save, but i still can't find the macro when i want to select it as discussed above.

Can you e-mail your file to me so I can actually see it (taking out any sensitive information)?

Mar 8th, 2002, 12:29 PM

Barrie

I've cracked it, I couldn't find it because it was a macro that opened up a message prompt only when the file is opened - sorry mate but thanks for your time.
I'm having a blonde day!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 11:14 AM	#1
Guest Posts: n/a	After copying a macro and then pasting it into the visual basic editor, how do i then save it so that when i go to macros and attempt to run it it appears.? Sorry for being very dense!

Mar 8th, 2002, 11:42 AM	#3
Guest Posts: n/a	should i then be able to open this thro' tools>macro>macros, because that's what i want to do but still don't seem to be having any luck?!

Mar 8th, 2002, 11:58 AM	#5
Guest Posts: n/a	Sorry Barrie, still no joy - after selecting the workbook (VBAProject newtest.xls), i then inserted the module and pasted my macro. Then saved - file>save newtest.xls, it appeared to save, but i still can't find the macro when i want to select it as discussed above.

Mar 8th, 2002, 12:29 PM	#7
Guest Posts: n/a	Barrie I've cracked it, I couldn't find it because it was a macro that opened up a message prompt only when the file is opened - sorry mate but thanks for your time. I'm having a blonde day!