Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with saving a Macro
Hi All, any help would be appreciated.
I'm new to using macros (Excel 2003) and I cannot seem to understand where to save a macro so that is it accessible to me whenever I open Excel. I've tried saving it in my personal workbook, but whenever I try to "view" the visual basic language my macro seems to dissapear. My end goal is actually to try to get a macro saved "somewhere" that is accessible to our whole company to use if needed, but I'm lost as to where to even begin. I've gone through the "record a macro" senerio 4 times now and still, each time I try to "edit" the macro I lose it. Am I saving when I shouldn't be? or Not saving. Any help I try to look up on the webiste talks about Modules? What is a Module? Am I creating the macro wrong all together? Any help/answers are appreciated, but please be very basic in your explanation, I'm very new to macros and the terminology. I have created them years ago, but I'm very rusty and it never seemed to be this difficult in the past. -- Thank you, Patty |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with saving a Macro
No matter which workbook you record a macto to, a Module will be created with
the recorded steps. Alt + F11 to open the Visual Basic Editor. CTRL + r to open the Project Explorer. Find your workbook with the macro(s) in it. If you have recorded to Personal Macro Workbook then you should see Personal.xls Expand that workbook to see the Module1 or Module2 etc. Double-click on the Module to open for editing. I would suggest for company-wide availability you copy all macros into a module in a new workbook. Save that workbook as an Add-in which you make accessible to all, either by storing in a common location or distributing to work stations. Don't mess about with others' Personal.xls files. Gord Dibben MS Excel MVP On Tue, 1 Apr 2008 10:32:01 -0700, Keepsmiling1228 wrote: Hi All, any help would be appreciated. I'm new to using macros (Excel 2003) and I cannot seem to understand where to save a macro so that is it accessible to me whenever I open Excel. I've tried saving it in my personal workbook, but whenever I try to "view" the visual basic language my macro seems to dissapear. My end goal is actually to try to get a macro saved "somewhere" that is accessible to our whole company to use if needed, but I'm lost as to where to even begin. I've gone through the "record a macro" senerio 4 times now and still, each time I try to "edit" the macro I lose it. Am I saving when I shouldn't be? or Not saving. Any help I try to look up on the webiste talks about Modules? What is a Module? Am I creating the macro wrong all together? Any help/answers are appreciated, but please be very basic in your explanation, I'm very new to macros and the terminology. I have created them years ago, but I'm very rusty and it never seemed to be this difficult in the past. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving a macro | New Users to Excel | |||
Saving worksheets using a Macro | Excel Discussion (Misc queries) | |||
Macro to Automate Saving | Excel Discussion (Misc queries) | |||
Saving with Macro | Excel Discussion (Misc queries) | |||
Saving without Macro | Excel Discussion (Misc queries) |