Short cuts VBA

S

Stephen

I wrote a VBA macro that I use with a particular workbook. I wrote
this several years ago, and have not played with VBA too much since
then.
The short cut to the macro is "ctrl P". It causes the sheet to
print a certain area of the workbook. I would like to edit this macro,
but I can not find it. It is not in the hidden "personal workbook". It
is not within the workbook in question. How do I search for such an
animal.
 
D

David McRitchie

Hi Stephen,

Search within the Visual Basic Editor:
ALT+F11 to get to the Visual Basic Editor (VBE)
Ctrl+R Object Explorer
select the first workbook of your own, the first module within
which brings up the Code (F7) for that module
Ctrl+F for Find
Find what:: Print
within: current project
Keep hitting Next button until you find it in your project (workbook)
If not found try the same in the next workbook.

If you will recognize the name if you see it this may work better for you.
Subroutine and Function Table for Open Workbooks (#ListFunctionsAndSubs)
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#ListFunctionsAndSubs
also see within same webpage
GoToSub -- Display Subroutine named in selected cell (#GoToSub)
 
Top