How can i find the macro

[Thomas_G]

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

[VBA Noob]

See if link helps

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

VBA Noob

[Thomas_G]

It didnt help. i dont have any "modeule folders" so it cant be that

What else could it be ?

[VBA Noob]

See if this link helps

Deleting All VBA Code In A Project

VBA Noob

[Thomas_G]

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.

Please Login or Register  to view this content.

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

[VBA Noob]

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

VBA Noob

[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

[Thomas_G]

you got mail

[VBA Noob]

Right Click sheet tab called

Overblik

and select view code and remove the line

Please Login or Register  to view this content.

then save workbook and reopen

VBA Noob

[Thomas_G]

Oh man thats lovely. thanks a million.

Now its time to wonder how it came there in the first place :p

but again thanks alot

/Thomas

[VBA Noob]

Your welcome

VBA Noob