Excel 2007 not prompting blocked content with message bar

  • Thread starter Thread starter png
  • Start date Start date
P

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?
 
Maybe the file is located in a "trusted" location?
Click to expand...

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?
 
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
 
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"
Click to expand...

"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?


 
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
 
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.
Click to expand...

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

Virus scan came up clean.


 
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?
Click to expand...

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

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

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.
 
Did you try clicking "Options..." on the message bar? This displays a
dialog where you can enable macros.
Click to expand...

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.
 
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.
Click to expand...

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'.
 
On 2/1/2011 8:40 AM, GS wrote:
the location where the wkb is stored is listed as 'Trusted'.
Click to expand...

This, along with using an old version of the xlsx file, was the issue.
It has now been resolved. Thanks for your help!
 
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!
Click to expand...

Great! You're welcome!
 
Back
Top