macro question

  • Thread starter Thread starter Joe
  • Start date Start date
Couple of ways

open the wb, press alt + f11, select the module in the
project pane to the left, right click it. Select remove
module and select no when prompted if you want to export
it. Also right click each sheet tab and select view code
(or double click to the left in the project pane)to see
if you have any code there, if so just delete it, finally
double click ThisWorkbook in the project pane to make
sure there is no code there as well. Close the VBA editor
and save the workbook

Regards,

Peo Sjoblom
 
Thanks Peo,
There was no module in the project pane. I didi the other
instructions. I still get a message that there is a macro.
anything else?
Thanks, Joe
 
Thanks Paul,
Your link is exactely what I was looking for, however it
didn't work. There were no module folders, or Forms
folder or Class Modules folder. I followed all other
available instructions and I still get a message that I
have a macro. any other suggestion?
Thanks, Joe
 
Joe, that "should" have done it, there is and addin, ASAP utilities that
will remove all VBA in a workbook, and do many other handy things, have a
look at it here
http://www.asap-utilities.com/

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Paul, Thank you again. I checked out that site also. Then
went back to my worksheet and playing around I found the
macro tab in the lower left corner next to sheet1 tab and
right clicked on it and then selected delete and it was
gone. Problem solved!
Thanks again for your help. It led me to the solution.
Joe
 
Back
Top