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

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
HIS


"Hari Prasadh" wrote in message
...
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

Option Explicit is enough to trigger macor warnings!

DM Unseen

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" wrote in message
ups.com...
Option Explicit is enough to trigger macor warnings!

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

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" wrote in message
oups.com...
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

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" wrote in message
...
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
HIS


"Hari Prasadh" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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
HIS


"Hari Prasadh" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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
HIS


"Hari Prasadh" wrote in message
...
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

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 FormatSheetUnhide...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
HIS


"Hari Prasadh" wrote in message
...
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" wrote in message
...
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
HIS


"Hari Prasadh" wrote in message
...
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