workbook does not conatin macros but ....

[deebaglee]

hi every time i try and open a excel spreadsheet i keep getting the "this workbook conatains macros.....
but i did not create any macros!

 

[carrr]

Open VB Editor (Alt+F11). Look under the heading of the workbook in question and right click on any modules you find. Select remove module and NO to export. THis should clean out any problems.

 

[deebaglee]

sorry not to good with vb what is a module?

 

[xlbo]

In excel press Alt+F11
This will take you to the VBE

You should be able to see a window called "Projects"
Under your workbook name, you should see objects for each sheet in the workbook and a thisworkbook object
Under that, it should list any modules - do what carr suggests for each of the modules you can see in there

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[deebaglee]

thank you for clearing that up Geoff, i have had a look and there are no modules listed!

 

[xlbo]

Try double clicking on the sheet and workbook objects
there may be code in them

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[Dreamboat]

LOL! You can use this code to delete the code:

Deleting All VBA Code In A Project

The procedure below will delete all the VBA code in a project. You should use this procedure with care, as it will permanently delete the code. Standard modules, user forms, and class modules will be removed, and code within the ThisWorkbook module and the sheet modules will be deleted. You may want to export the VBA code, using the procedure above, before deleting the VBA code.

Sub DeleteAllVBA()

Dim VBComp As VBIDE.VBComponent
Dim VBComps As VBIDE.VBComponents

Set VBComps = ActiveWorkbook.VBProject.VBComponents

For Each VBComp In VBComps
Select Case VBComp.Type
Case vbext_ct_StdModule, vbext_ct_MSForm, _
vbext_ct_ClassModule
VBComps.Remove VBComp
Case Else
With VBComp.CodeModule
.DeleteLines 1, .CountOfLines
End With
End Select
Next VBComp

End Sub


COURTESY OF CHIP PEARSON'S SITE:

http://www.cpearson.com/excel/vbe.htm

Anne Troy

http://www.VBAExpress.com

 

[deebaglee]

hi scanned through but nothing
should i be looking at the props of the sheets and objects?

 

[cheerio]

This warning can also be generated by Excel 4 macros.

 

[deebaglee]

thanks folks i will try this out when i get back to the office