Hy guys
I search the net, the forum here and every where, and i still have no clue how to do it. Maybe one genius MrExcel will help me.
Here's the problem, i got a invoice, on my invoice i create dropdown menu link with a macro. when i choose sellers or compagny in those drop down(yeah i got one for each) the macro replace all my name and adresse on my invoice. BUT that invoice, i copy it once it finish to another workbook. But when i open it, he still want to open those link for the drop down menu. But i will never use it anymore when it already move. So i would love to insert a line into my macro to copy the sheet in another workbook but without all those link. So when i reopen it, excel don't botter me anymore about those link.
I can show you all my macro's if you need it, i just don't past it right now because it pretty big.
Thanks
Michellin
I search the net, the forum here and every where, and i still have no clue how to do it. Maybe one genius MrExcel will help me.
Here's the problem, i got a invoice, on my invoice i create dropdown menu link with a macro. when i choose sellers or compagny in those drop down(yeah i got one for each) the macro replace all my name and adresse on my invoice. BUT that invoice, i copy it once it finish to another workbook. But when i open it, he still want to open those link for the drop down menu. But i will never use it anymore when it already move. So i would love to insert a line into my macro to copy the sheet in another workbook but without all those link. So when i reopen it, excel don't botter me anymore about those link.
I can show you all my macro's if you need it, i just don't past it right now because it pretty big.
Thanks
Michellin