| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where do macros go?
Where exactly do you put them?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where do macros go?
Macros are stored in VBA Modules, or in worksheet and workbook modules. By
default, when you record a macro it's placed in a module named Module# where # is the next available module number and saved with the current workbook. To make macros available to all workbooks you can place them in a workbook named PERSONAL.XLS, which opens up in the background each time you start Excel, but is hidden from view. Click WINDOW and select UNHIDE to actually view the PERSONAL workbook. -- Kevin Backmann "STEVE" wrote: Where exactly do you put them? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where do macros go?
That doesn't answer my question exactly does it?
Step-by-step, where do I enter a macro please? "Kevin B" wrote: Macros are stored in VBA Modules, or in worksheet and workbook modules. By default, when you record a macro it's placed in a module named Module# where # is the next available module number and saved with the current workbook. To make macros available to all workbooks you can place them in a workbook named PERSONAL.XLS, which opens up in the background each time you start Excel, but is hidden from view. Click WINDOW and select UNHIDE to actually view the PERSONAL workbook. -- Kevin Backmann "STEVE" wrote: Where exactly do you put them? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where do macros go?
Two ways.
Click on Tools Macro, Record New Macro. Go through the motions as you would like the macro to do it, and at the end click on Stop Recording. Now press <Alt<F11 to go to VBE, in the left hand window, find the workbook you were working in, double click on Module1 below that, and you will see your code. Else, Press <Alt<F11, find the workbook you want to write the macro in, click on Insert|Module. Now, in the right hand window, type away? -- kassie never stop learning "STEVE" wrote in message ... That doesn't answer my question exactly does it? Step-by-step, where do I enter a macro please? "Kevin B" wrote: Macros are stored in VBA Modules, or in worksheet and workbook modules. By default, when you record a macro it's placed in a module named Module# where # is the next available module number and saved with the current workbook. To make macros available to all workbooks you can place them in a workbook named PERSONAL.XLS, which opens up in the background each time you start Excel, but is hidden from view. Click WINDOW and select UNHIDE to actually view the PERSONAL workbook. -- Kevin Backmann "STEVE" wrote: Where exactly do you put them? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where do macros go?
Thanks...that's what I was looking for!
"Kassie" wrote: Two ways. Click on Tools Macro, Record New Macro. Go through the motions as you would like the macro to do it, and at the end click on Stop Recording. Now press <Alt<F11 to go to VBE, in the left hand window, find the workbook you were working in, double click on Module1 below that, and you will see your code. Else, Press <Alt<F11, find the workbook you want to write the macro in, click on Insert|Module. Now, in the right hand window, type away? -- kassie never stop learning "STEVE" wrote in message ... That doesn't answer my question exactly does it? Step-by-step, where do I enter a macro please? "Kevin B" wrote: Macros are stored in VBA Modules, or in worksheet and workbook modules. By default, when you record a macro it's placed in a module named Module# where # is the next available module number and saved with the current workbook. To make macros available to all workbooks you can place them in a workbook named PERSONAL.XLS, which opens up in the background each time you start Excel, but is hidden from view. Click WINDOW and select UNHIDE to actually view the PERSONAL workbook. -- Kevin Backmann "STEVE" wrote: Where exactly do you put them? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where do macros go?
Glad I could be of assistance! Thanks for the response
-- kassie never stop learning "STEVE" wrote in message ... Thanks...that's what I was looking for! "Kassie" wrote: Two ways. Click on Tools Macro, Record New Macro. Go through the motions as you would like the macro to do it, and at the end click on Stop Recording. Now press <Alt<F11 to go to VBE, in the left hand window, find the workbook you were working in, double click on Module1 below that, and you will see your code. Else, Press <Alt<F11, find the workbook you want to write the macro in, click on Insert|Module. Now, in the right hand window, type away? -- kassie never stop learning "STEVE" wrote in message ... That doesn't answer my question exactly does it? Step-by-step, where do I enter a macro please? "Kevin B" wrote: Macros are stored in VBA Modules, or in worksheet and workbook modules. By default, when you record a macro it's placed in a module named Module# where # is the next available module number and saved with the current workbook. To make macros available to all workbooks you can place them in a workbook named PERSONAL.XLS, which opens up in the background each time you start Excel, but is hidden from view. Click WINDOW and select UNHIDE to actually view the PERSONAL workbook. -- Kevin Backmann "STEVE" wrote: Where exactly do you put them? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Strip workbook of macros, VBA, MS Query, etc. | Excel Discussion (Misc queries) | |||
| Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
| how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
| Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
| Enabling macros | Excel Discussion (Misc queries) | |||
Linear Mode
