macro security problem

[Guest]

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

 

[Guest]

Using the VBA editor, remove all the modules that held the macros, as well as
the macros themselves

 

[Guest]

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.

 

[Pete_UK]

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

 

[Gord Dibben]

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