Excel Odd Opening

[MoonMullen]

I have a workbook that when I open it the "macro virus protection" dialog box opens. I have deleted all modules and made sure that there are no procedures on any worksheets within the workbook. There are no procedures on the ThisWorkbook object either. I closed and saved the workbook and then re-open it. The "macro virus protection" dialog box comes up again. How is this possible? In addition, when the book opens it always goes to a particular worksheet within the workbook. I have saved the workbook on a different worksheet. When I open it again the workbook displays the worksheet I saved at for a second or two and then jumps to this particular worksheet. How can it do that without any code running? Can a module sheet be hidden from the Visual Basic Editor? I

 

[Dreamboat]

Insert-Name-Define

Click on any names in your file and make sure they don't refer to something you're unsure of. Defined names can contain formulas, etc., and, for some reason, this can cause the macro alert.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com