I think that you might have to consider "modules" in the wider sense. In VB,
each worksheet object has the capacity to store code as does the
"ThisWorkbook" object. Check each of these and ensure that no blank lines
are present.
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"Bob Smith" <usirsclt_No_Spamola_[ at ]earthlink.net> wrote in message
news:1J8Tg.7652$UG4.499[ at ]newsread2.news.pas.earthlink.net...
[Quoted Text] > Thanks for the reply Brink. Unfortunately, no modules show up under the
> list of worksheets.
>
> Bob
>
> <brinkcor[ at ]gmail.com> wrote in message
> news:1159431555.549389.38680[ at ]m7g2000cwm.googlegroups.com...
>> Look in VB where you will usually add code of some sort. Below your
>> listed worksheets are modules listed, delete these modules, problem
>> should be solved.
>>
>> Bob Smith wrote:
>>> Hi folks,
>>>
>>> I have a 30 worksheet file, where each time I open it up, it asks to
>>> either
>>> enable or disable a macro. There is no macro on this file when going to
>>> Tools-Macros. I've check the file through VB and can't find any macro.
>>>
>>> I checked personal.xls and there is no macro in that as well.
>>>
>>> Any other suggestions you might provide to get rid of this warning
>>> message
>>> would be appreciated.
>>>
>>> TIA, Bob
>>
>
>
|