Excel 2007 not prompting blocked content with message bar

[png]

even when I go into trust center and make sure that this feature is
enabled. The excel file in question does have a macro that normally is
blocked on other machines here with the message bar prompting about the
blocked content. Can any help please?

 

[Jim Cone]

Maybe the file is located in a "trusted" location?
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Extras for Excel add-in: convenience built-in)


"png" <[email protected]>
wrote in message
news:[email protected]...

 

[png]

Maybe the file is located in a "trusted" location?

Hi Jim and thanks for the reply. I don't think that is the problem, let
me explain why. excel 2007 is blocking the functionality of the macro,
but not prompting with the message bar to enable content.

If it is in a trusted location (it's on the hdd now), how would I find out?

please?

 

[Jim Cone]

Go to the Trust Center | Trust Center Settings | Macro Settings - "Disable all macros with
notification" should be check marked.

Re: "If it is in a trusted location (it's on the hdd now), how would I find out?"
Same route as above except "Trusted Locations" instead of "Macro Settings"
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(XL Companion add-in: compares, matches, counts, lists, finds, deletes...)





"png" <[email protected]>
wrote in message

 

[png]

Go to the Trust Center | Trust Center Settings | Macro Settings - "Disable all macros with
notification" should be check marked.

Re: "If it is in a trusted location (it's on the hdd now), how would I find out?"
Same route as above except "Trusted Locations" instead of "Macro Settings"

"Disable all macros with notification" is checked, and so is "Show the
message bar in all applications when content has been blocked", but it
is not prompting with the message bar.

I added the location of the document to trusted locations.

So now the form is working (thanks for that), but it does not seem the
macro security in excel is working properly, specifically the message
bar. What do you recommend next?

Thanks again for your ongoing help.

find out?

 

[Jim Cone]

If the file is in a trusted location then no warning message is displayed.
Files should be scanned by the computer operator (you) before moving them to a trusted
location.
I am not certain what your other concern(s) is.
In any case, I would make sure to do a complete virus scan. I usually start one of those
just before going to lunch.

--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Formats & Styles: lists or removes unused styles & number formats - in the free folder)




"png" <[email protected]>
wrote in message

 

[png]

If the file is in a trusted location then no warning message is displayed.
Files should be scanned by the computer operator (you) before moving them to a trusted
location.
I am not certain what your other concern(s) is.
In any case, I would make sure to do a complete virus scan. I usually start one of those
just before going to lunch.

There is no message displayed whether the file is in a trusted location
or not.

Virus scan came up clean.

 

[Jim Cone]

I am out of ideas.
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Lottery Numbers.xls - in the free folder)




"png" <[email protected]>
wrote in
message news:[email protected]...

 

[png]

I am out of ideas.
'---
Jim Cone

Dang. But thanks very much for your help anyway.

Can anyone else help please?

 

[GS]

png explained :

Hi Jim and thanks for the reply. I don't think that is the problem, let me
explain why. excel 2007 is blocking the functionality of the macro, but not
prompting with the message bar to enable content.

If it is in a trusted location (it's on the hdd now), how would I find out?


please?

Did you try clicking "Options..." on the message bar? This displays a
dialog where you can enable macros.

 

[png]

png explained :

Did you try clicking "Options..." on the message bar? This displays a
dialog where you can enable macros.

Hi GS. My problem is that even though I have trust center message bar
settings set as "Show the message bar in all applications when content
has been blocked", it is inconsistently blocking content and never
displaying the message bar. I also have trust center macro settings set
as "disable all macros with notification", so I'm very confused as to
why it is not working properly.

Thanks for your reply.

 

[png]

Did you try clicking "Options..." on the message bar? This displays a
dialog where you can enable macros.

Hi GS. My problem is that even though I have trust center message bar
settings set as "Show the message bar in all applications when content
has been blocked", it is inconsistently blocking content and never
displaying the message bar. I also have trust center macro settings set
as "disable all macros with notification", so I'm very confused as to
why it is not working properly.

Thanks for your reply.

Sorry about double post, I meant to post to both groups first time.

 

[GS]

png brought next idea :

Hi GS. My problem is that even though I have trust center message bar
settings set as "Show the message bar in all applications when content has
been blocked", it is inconsistently blocking content and never displaying the
message bar. I also have trust center macro settings set as "disable all
macros with notification", so I'm very confused as to why it is not working
properly.

Thanks for your reply.

I can't say I've ever seen this in any version. The behavior suggests
that Excel doesn't know the wkb has macros (ergo the wkb is corrupted),
OR the location where the wkb is stored is listed as 'Trusted'.

 

[png]

On 2/1/2011 8:40 AM, GS wrote:

the location where the wkb is stored is listed as 'Trusted'.

This, along with using an old version of the xlsx file, was the issue.
It has now been resolved. Thanks for your help!

 

[GS]

png explained on 2/16/2011 :

On 2/1/2011 8:40 AM, GS wrote:


This, along with using an old version of the xlsx file, was the issue. It has
now been resolved. Thanks for your help!

Great! You're welcome!