No Macro showing up

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Smith - 25 Sep 2006 21:38 GMT

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

Reply to this Message

brinkcor@gmail.com - 28 Sep 2006 09:19 GMT

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.

> Hi folks,
>
[quoted text clipped - 8 lines]
>
> TIA, Bob

Reply to this Message

Bob Smith - 29 Sep 2006 13:55 GMT

Thanks for the reply Brink. Unfortunately, no modules show up under the list
of worksheets.

Bob

> Look in VB where you will usually add code of some sort. Below your
> listed worksheets are modules listed, delete these modules, problem
[quoted text clipped - 14 lines]
>>
>> TIA, Bob

Reply to this Message

Andy Wiggins - 30 Sep 2006 14:38 GMT

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.

Signature

Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

> Thanks for the reply Brink. Unfortunately, no modules show up under the
> list of worksheets.
[quoted text clipped - 19 lines]
>>>
>>> TIA, Bob

Reply to this Message