S
STEVE
Where exactly do you put them?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin B
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.
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.
S
STEVE
That doesn't answer my question exactly does it?
Step-by-step, where do I enter a macro please?
Step-by-step, where do I enter a macro please?
K
Kassie
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
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
S
STEVE
Thanks...that's what I was looking for!
Kassie said: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?
K
Kassie
Glad I could be of assistance! Thanks for the response
--
kassie
never stop learning
--
kassie
never stop learning