View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Hari Prasadh[_2_] Hari Prasadh[_2_] is offline
external usenet poster
 
Posts: 83
Default No Macros but Macro enabling message

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