Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Where to save macros
I have two questions really. First, I was told there was a specific place to
save a macro if I wanted it to be avalable whenever I opened excel. Where would that be? Also, how do I create a macro that is always available when I open excel instead of spreadsheet specific. Thanks for your help. |
#2
|
|||
|
|||
If you do not already have a personal.xls record a macro to personal macro
workbook. When you close excel after that creation you will be asked if you want to save personal.xls say yes. Now it will be available to you. However this is a hidden workbook. -- Don Guillett SalesAid Software "Raewyn" wrote in message ... I have two questions really. First, I was told there was a specific place to save a macro if I wanted it to be avalable whenever I opened excel. Where would that be? Also, how do I create a macro that is always available when I open excel instead of spreadsheet specific. Thanks for your help. |
#3
|
|||
|
|||
Rae
Maybe Personal.xls which is a workbook that holds your global macros so's they are available for all open workbooks? Personal.xls is created the first time you record a Macro using Macro Recorder. ToolsMacroRecord New Macro. A dialog box will come up asking you name the macro and where to place it. Pick Personal Macro Workbook from the dropdown. Copy and paste a couple of cells then Stop Recording. You now have a Personal.xls in your Office\XLSTART folder. You can go to Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module. You can add more macros by recording or by typing/copying them into the Module. You can do a FileSave from there or better yet hit ALT + Q to return to the Excel window. Then with Personal.xls active, hit WindowHide. When you close Excel you will be asked if you want to save Personal.xls. Yes! It will open hidden next time you start Excel. NOTE: when assigning macros to buttons or menu items you will have to precede the macro name with Personal.xls. i.e. Personal.xls!macroname An alternative to Personal.xls is to create an add-in(*.xla) with your macros in it and load it through ToolsAdd-ins. The benefit of this is that you don't have to precede the macro name with the filename. A disadvantage is that you will not see the macros in the ToolsMacroMacros dialog. Gord Dibben Excel MVP On Thu, 28 Apr 2005 07:32:03 -0700, Raewyn wrote: I have two questions really. First, I was told there was a specific place to save a macro if I wanted it to be avalable whenever I opened excel. Where would that be? Also, how do I create a macro that is always available when I open excel instead of spreadsheet specific. Thanks for your help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where to save macros
Don, could we take this one step further please. New computer and it's been
a long while since I've had to start from scratch. When I try to record a macro, I get the message "Personal Macro Workbook in the startup folder must stay open for recording". All I have in my XLSTART folder is Personal.xls, that automatically opens when I enter excel, so it is open. I click OK, hoping to record a macro to "create" the folder. I get is "Unable to record". There is no file in Window - Unhide. Am I looking in the wrong place? Elli "Don Guillett" wrote: If you do not already have a personal.xls record a macro to personal macro workbook. When you close excel after that creation you will be asked if you want to save personal.xls say yes. Now it will be available to you. However this is a hidden workbook. -- Don Guillett SalesAid Software "Raewyn" wrote in message ... I have two questions really. First, I was told there was a specific place to save a macro if I wanted it to be avalable whenever I opened excel. Where would that be? Also, how do I create a macro that is always available when I open excel instead of spreadsheet specific. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Document won't save | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Missing "Save" and "Save As" functions | Excel Discussion (Misc queries) |