No Macros but Macro enabling message

[Hari Prasadh]

Hi,

I have a workbook which doesnt have any Modules folder (also NO macros) and
neither is there any code in individual worksheets/workbook (Only option
explicit is mentioned in each one of them). It also doesnt seem to have any
of the Xl 4 macro worksheets.

Some of the worksheets does have the control tool-box buttons.

When I open this worksheet, I get a message similar to " Do you want to
enable macros in this worksheet or not? etc...

Why am I getting the above message, as I dont have any code?

(I got this workbook from Web)

Thanks a lot,
Hari
India

[Nick Hodge]

Hari

In my experience you will only get this message if you have some code
somewhere and it can hide in many places

If you'd like to forward me the book I'll take a look

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"Hari Prasadh" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a workbook which doesnt have any Modules folder (also NO macros)
> and neither is there any code in individual worksheets/workbook (Only
> option explicit is mentioned in each one of them). It also doesnt seem to
> have any of the Xl 4 macro worksheets.
>
> Some of the worksheets does have the control tool-box buttons.
>
> When I open this worksheet, I get a message similar to " Do you want to
> enable macros in this worksheet or not? etc...
>
> Why am I getting the above message, as I dont have any code?
>
> (I got this workbook from Web)
>
> Thanks a lot,
> Hari
> India
>

[DM Unseen]

Option Explicit is enough to trigger macor warnings!

DM Unseen

[Hari Prasadh]

Hi Nick,

Didnt want to cause trouble for mail scanning the attachment from your and
my side, hence sending you the web-link.

The workbook - 96.5 KB- I talked about could be downloaded from (Probably
an UK university) -

http://www.mis.coventry.ac.uk/research/discus/samp.xls

Please guide me.

Thanks a lot,
Hari
India


"Nick Hodge" <[email protected]> wrote in message
news:%[email protected]...
> Hari
>
> In my experience you will only get this message if you have some code
> somewhere and it can hide in many places
>
> If you'd like to forward me the book I'll take a look
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> [email protected]HIS
>
>
> "Hari Prasadh" <[email protected]> wrote in message
> news:[email protected]...
>> Hi,
>>
>> I have a workbook which doesnt have any Modules folder (also NO macros)
>> and neither is there any code in individual worksheets/workbook (Only
>> option explicit is mentioned in each one of them). It also doesnt seem to
>> have any of the Xl 4 macro worksheets.
>>
>> Some of the worksheets does have the control tool-box buttons.
>>
>> When I open this worksheet, I get a message similar to " Do you want to
>> enable macros in this worksheet or not? etc...
>>
>> Why am I getting the above message, as I dont have any code?
>>
>> (I got this workbook from Web)
>>
>> Thanks a lot,
>> Hari
>> India
>>
>
>

[Hari Prasadh]

Hi DM,

I create a new-workbook with Ctrl+N and then check out the VBE and see that
Option Explicit is added by VBE automatically (I have the option for it
checked in my VB, so I believe new wkbooks have this line added auto.)

I saved the above wkbok with no changes and reopened the same in a new excel
session. I did NOT get any Macro warnings, so not sure whether Option
explicit is enough to trigger messages.

Thanks a lot,
Hari
India

"DM Unseen" <[email protected]> wrote in message
news:[email protected]...
> Option Explicit is enough to trigger macor warnings!
>
> DM Unseen
>

[DM Unseen]

Hari,

Sorry for the confusion,
Option Explicit only triggers a warning when it is in a code/class
module. It will not trigger a warning when it is in a sheet or
workbook.

DM Unseen

[Hari Prasadh]

Hi DM,

If ur talking about the "code" , then even if a single comment (and nothing
else) is there in any module then it would trigger a message.

Thanks a lot,
Hari
India


"DM Unseen" <[email protected]> wrote in message
news:[email protected]...
> Hari,
>
> Sorry for the confusion,
> Option Explicit only triggers a warning when it is in a code/class
> module. It will not trigger a warning when it is in a sheet or
> workbook.
>
> DM Unseen
>

[Mike Fogleman]

There is a hidden sheet named "Sampling Macros" that has just that. The book
is an Excel 4.0 with a macro sheet and those macros cannot be disabled, that
I am aware of.

Mike F
"Hari Prasadh" <[email protected]> wrote in message
news:[email protected]...
> Hi Nick,
>
> Didnt want to cause trouble for mail scanning the attachment from your and
> my side, hence sending you the web-link.
>
> The workbook - 96.5 KB- I talked about could be downloaded from (Probably
> an UK university) -
>
> http://www.mis.coventry.ac.uk/research/discus/samp.xls
>
> Please guide me.
>
> Thanks a lot,
> Hari
> India
>
>
> "Nick Hodge" <[email protected]> wrote in message
> news:%[email protected]...
>> Hari
>>
>> In my experience you will only get this message if you have some code
>> somewhere and it can hide in many places
>>
>> If you'd like to forward me the book I'll take a look
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> [email protected]HIS
>>
>>
>> "Hari Prasadh" <[email protected]> wrote in message
>> news:[email protected]...
>>> Hi,
>>>
>>> I have a workbook which doesnt have any Modules folder (also NO macros)
>>> and neither is there any code in individual worksheets/workbook (Only
>>> option explicit is mentioned in each one of them). It also doesnt seem
>>> to have any of the Xl 4 macro worksheets.
>>>
>>> Some of the worksheets does have the control tool-box buttons.
>>>
>>> When I open this worksheet, I get a message similar to " Do you want to
>>> enable macros in this worksheet or not? etc...
>>>
>>> Why am I getting the above message, as I dont have any code?
>>>
>>> (I got this workbook from Web)
>>>
>>> Thanks a lot,
>>> Hari
>>> India
>>>
>>
>>
>
>

[Nick Hodge]

Hari

As has been pointed out this has a hidden XLM (V4) macro sheet which is
triggering the warning. If you do not need the functionality it gives you,
you can go to Format>Sheet>Unhide...SAMPLING MACRO and delete the sheet in
the usual way. This then gets rid of the pop-up

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"Hari Prasadh" <[email protected]> wrote in message
news:[email protected]...
> Hi Nick,
>
> Didnt want to cause trouble for mail scanning the attachment from your and
> my side, hence sending you the web-link.
>
> The workbook - 96.5 KB- I talked about could be downloaded from (Probably
> an UK university) -
>
> http://www.mis.coventry.ac.uk/research/discus/samp.xls
>
> Please guide me.
>
> Thanks a lot,
> Hari
> India
>
>
> "Nick Hodge" <[email protected]> wrote in message
> news:%[email protected]...
>> Hari
>>
>> In my experience you will only get this message if you have some code
>> somewhere and it can hide in many places
>>
>> If you'd like to forward me the book I'll take a look
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> [email protected]HIS
>>
>>
>> "Hari Prasadh" <[email protected]> wrote in message
>> news:[email protected]...
>>> Hi,
>>>
>>> I have a workbook which doesnt have any Modules folder (also NO macros)
>>> and neither is there any code in individual worksheets/workbook (Only
>>> option explicit is mentioned in each one of them). It also doesnt seem
>>> to have any of the Xl 4 macro worksheets.
>>>
>>> Some of the worksheets does have the control tool-box buttons.
>>>
>>> When I open this worksheet, I get a message similar to " Do you want to
>>> enable macros in this worksheet or not? etc...
>>>
>>> Why am I getting the above message, as I dont have any code?
>>>
>>> (I got this workbook from Web)
>>>
>>> Thanks a lot,
>>> Hari
>>> India
>>>
>>
>>
>
>

[Hari Prasadh]

Hi Mike and Nick,

Thnx for your help.

Too foolish of me to not even check for hidden sheets.

Thanks a lot,
Hari
India

"Mike Fogleman" <[email protected]> wrote in message
news:[email protected]...
> There is a hidden sheet named "Sampling Macros" that has just that. The
> book is an Excel 4.0 with a macro sheet and those macros cannot be
> disabled, that I am aware of.
>
> Mike F
> "Hari Prasadh" <[email protected]> wrote in message
> news:[email protected]...
>> Hi Nick,
>>
>> Didnt want to cause trouble for mail scanning the attachment from your
>> and my side, hence sending you the web-link.
>>
>> The workbook - 96.5 KB- I talked about could be downloaded from
>> (Probably an UK university) -
>>
>> http://www.mis.coventry.ac.uk/research/discus/samp.xls
>>
>> Please guide me.
>>
>> Thanks a lot,
>> Hari
>> India
>>
>>
>> "Nick Hodge" <[email protected]> wrote in message
>> news:%[email protected]...
>>> Hari
>>>
>>> In my experience you will only get this message if you have some code
>>> somewhere and it can hide in many places
>>>
>>> If you'd like to forward me the book I'll take a look
>>>
>>> --
>>> HTH
>>> Nick Hodge
>>> Microsoft MVP - Excel
>>> Southampton, England
>>> [email protected]HIS
>>>
>>>
>>> "Hari Prasadh" <[email protected]> wrote in message
>>> news:[email protected]...
>>>> Hi,
>>>>
>>>> I have a workbook which doesnt have any Modules folder (also NO macros)
>>>> and neither is there any code in individual worksheets/workbook (Only
>>>> option explicit is mentioned in each one of them). It also doesnt seem
>>>> to have any of the Xl 4 macro worksheets.
>>>>
>>>> Some of the worksheets does have the control tool-box buttons.
>>>>
>>>> When I open this worksheet, I get a message similar to " Do you want to
>>>> enable macros in this worksheet or not? etc...
>>>>
>>>> Why am I getting the above message, as I dont have any code?
>>>>
>>>> (I got this workbook from Web)
>>>>
>>>> Thanks a lot,
>>>> Hari
>>>> India
>>>>
>>>
>>>
>>
>>
>
>