How can i find the macro

Hello

I have an excel document that everytime i open it, it asks me if i want to use it with or without macros. I havent used any macros in the document, so i cant see why it should ask for that.

Is there a way to see macro that should be there or disable the macros in the document so it wont ask taht question

Thanks
Thomas G

See if link helps

http://exceltips.vitalnews.com/Pages...om_Macros.html

VBA Noob

See if this link helps

Deleting All VBA Code In A Project

VBA Noob

Hej

Not much of this makes any sence to me. Mostly becourse my english is lagging a bit, and second that im not very good at programming anything :p

i guess whe it should do is this ?

Deleting All VBA Code In A Project

This code will delete ALL VBA code in a VBProject.

    Sub DeleteAllVBACode()
        Dim VBProj As VBIDE.VBProject
        Dim VBComp As VBIDE.VBComponent
        Dim CodeMod As VBIDE.CodeModule
        
        Set VBProj = ActiveWorkbook.VBProject
        
        For Each VBComp In VBProj.VBComponents
            If VBComp.Type = vbext_ct_Document Then
                Set CodeMod = VBComp.CodeModule
                With CodeMod
                    .DeleteLines 1, .CountOfLines
                End With
            Else
                VBProj.VBComponents.Remove VBComp
            End If
        Next VBComp
    End Sub

but where should i put it, and does it needs to be compiled or something like that ?

I could upload the file to here if u maybe have time to take a look at it ?

/Thomas

Please read forum rules below and then wrap your code as per rule 5

VBA Noob

Thanks for wrapping code

If you like send me a private message with your e-mail address and I will reply so you can send me the file

or post the file here and I'll take a look

VBA Noob