Remove the modules even though empty.

Also check through Thisworkbook module and Sheet modules for extraneous lines of
code to delete.

By the way, what sort of macros did you have that gave you a speed problem and
"calculating cell" message?


Gord Dibben MS Excel MVP

On Tue, 6 Nov 2007 16:47:02 -0800, peyman
wrote:

I did so.but still the message comes up!!!
I removed the codes in the modules not the modules themselves!I have the
list of modules like module 1,2,... but they are blank.

"Gary''s Student" wrote:

Using the VBA editor, remove all the modules that held the macros, as well as
the macros themselves
--
Gary''s Student - gsnu200754


"peyman" wrote:

hi,
I've had a file with a couple of macros and because of the speed problem and
"calculating cell" process I removed all of the macros.
when I'm gonna share the file the following message comes up:
"This workbook contains macros recorded or written in Visual Basic.Macros
can naot be viewed or edited in shared workbooks."
But I know that I have absolutely no macros recorded or written or downloaded.
the macros I removed were written by me.
Any idea in this regard?
thanks