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).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!
Is this explanation sufficient?
Like this thread? Share it with others