Macros

S

Steve

I didn't see a group for Excel Macros so I'm posting here. I created a
macro, saved it in the workbook that I was working on, gave it a short cut
key stroke and it all worked perfectly. When done with the exercise I
deleted the macro from that workbook. When I open a new workbook the ctrl
key still activates the macro. I can't find where or how I delete the short
cut key combo for that macro? All help is appreciated. Thanks in advance.

SteveR
 
D

Dodo

I didn't see a group for Excel Macros so I'm posting here. I created a
macro, saved it in the workbook that I was working on, gave it a short
cut key stroke and it all worked perfectly. When done with the
exercise I deleted the macro from that workbook. When I open a new
workbook the ctrl key still activates the macro. I can't find where
or how I delete the short cut key combo for that macro? All help is
appreciated. Thanks in advance.
Click to expand...

Are you certain it is not saved into your personal.xls?
 
S

Steve

What is "personal.xls"? Is this a file? folder? How do I find this? I'm not
sure of your answer?
 
D

Dave Peterson

Personal.xls is an excel workbook that's usually stored in your XLStart folder.
If you don't do anything special, the first time it's created (and saved), it
will be a hidden workbook--so you may not notice it.

If you created the macro by recording your actions, you may have chosen
personal.xls in that first dialog. (There's a dropdown list asking where the
recorded macro should be stored.)

And lots of people use this personal.xls workbook to store macros that they want
available each time they open excel (hence the XLStart folder--you can find that
by using Windows start button|search and looking for XLStart).

You can check to see if you have a hidden Personal.xls workbook open by:

Start excel (normally)
window|Unhide
(If that option is greyed out, you don't have a hidden workbook of any name)
If that option is available, you can unhide it if you wish, but it's not
necessary for this exercise.

Hit alt-f11 (to get to the VBE)
hit ctrl-r (to see the project explorer--like windows explorer)

You'll see a list of all the workbooks/projects you have open. (they'll be the
bold items that are the highest branch in each tree--kind of like subfolders in
the root folder of your harddrive).

Start looking through those projects (expand the +'s to view all the
objects/folders under each project)--although I would start with personal.xls.

When you see folders that are named Module1, Module2, ...

Double click on each looking for your macro.

After you review all the modules, you'll have to make a decision:

Did you create personal.xls in error or did you just create an extra version of
the macro?

If you just created an extra version of the macro, you can delete that
subroutine (or the module that contains the subroutine if there's nothing else
required in it). Just right click on the module name and select "remove
module#". You can answer no to the export prompt if you don't want to create a
text file with your macro code in it.

Then back to excel and close excel--answer yes to the "wanna save personal.xls"
prompt.

=====
 
Top