After deleting the code text, closing visual basic and
saving the workbook, when the workbook is reopened, the
macro virus checker still comes up. When I check the code
to see that it is removed, I notice that it is still
there, yet I deleted it just as you said.
Sorry I couldn't respond right away, I left work, I'm back
now until about 2pm Eastern time, but feel free to send e-
mail to me at the address listed. I will be working here
only until mid-week next week.
-----Original Message-----
Yes, he does, on two worksheets. I sent him directions, just have not heard
back.
Are you one h*ll of a psychic or did he send you the file?
--
Laura Cook
Appleton, WI
Laura, he has the remnants of event macros in his sheet modules.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP
--------------------------------------------------------
------------------ ------------------
--
Try checking the "Microsoft Excel Objects" folder (above the Module
folder). Double click on each item listed under it
and remove any code.
If
all else fails, you can send me the file (if that's
okay) and I'll take
a
look for you.
--
Laura Cook
Appleton, WI
Someone else gave me the same advice and it worked great
for one out of the five workbooks I have this problem
with. It solved the problem for the one workbook, but the
other workbooks don't have any modules to delete. So, do
you have any other suggestions?
-----Original Message-----
Open the workbook. Right-click on a sheet tab and
select "View Code".
Visual Basic will open and on the left-hand side, you
will see a list of
workbooks you have open. The sheet you right- clicked on
should be the
active/selected sheet. All the sheets for that workbook
are listed under a
folder called "Microsoft Excel Objects". The folder
below that one is
"Modules". This is where *most* macros are stored, at
least from the
description of your post this is where they are/were
located. If there are
any modules (Module1, Module2, etc...) in this folder
delete them
(right-click on it and choose "Remove Module").
This should stop the warning upon opening.
--
HTH,
Laura Cook
Appleton, WI
message
I created a macro to help me with a few workbooks and
then
I deleted it. The quick key I created no longer works
which is good, because I want the macro gone, yet when I
open the workbook, I still get asked by the macro virus
checker if I want to enable the macros. What macros, I
thought I got rid of them. Please help me.
.
.
