macro security problem
 

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

macro security problem
 

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

macro security problem
 

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

macro security problem
 

You need to delete the modules. Right-click on Module 1, then click
Remove Module 1 - Excel will ask if you want to export the module
before removing, but just click No. Do this for every module you have.
Close the VBE window and save the file, then you shouldn't have the
warning message next time you open it.

Hope this helps.

Pete

On Nov 7, 12:47 am, 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- Hide quoted text -

- Show quoted text -

macro security problem
 

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