Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Excel 2007 Macro security problem.

Hi All,

I have several macros (self published) that I have run in Excell 97 all the
way through 2003). These are very basic macros create with the recorder. When
I upgraded to 2007, none of the macros will work. They are blocked with
security warnings. I have verified that I am listed as a trusted publisher.
I have even turned security off, it does not seem to matter, the macros won't
run.

The message states, "...because of your security settings, macros have been
disabled. Please close and then re-open the workbook and choose enable macros"

Enable macros has never appeared in my workbook. (I am using Excel 2007
..XLSM format)

Any idea's?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 226
Default Excel 2007 Macro security problem.

Hi Andy

not sure if this will help any but when i tried the beta version i
found the same thing though excel was asking me if i wanted to let the
macros run i just didn't see it as it popped up just below the menu
ribbon.

anywho i hope this is of some use to you

S


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Excel 2007 Macro security problem.

Thanks for the help, but no, there is no bar :-(

"Incidental" wrote:

Hi Andy

not sure if this will help any but when i tried the beta version i
found the same thing though excel was asking me if i wanted to let the
macros run i just didn't see it as it popped up just below the menu
ribbon.

anywho i hope this is of some use to you

S



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro security in Excel 2007 jodleren Excel Discussion (Misc queries) 1 September 3rd 09 03:59 PM
EXCEL 2007 Macro Security Being Ignored Libby H Excel Discussion (Misc queries) 5 June 5th 09 09:01 PM
Selective Macro Security in Excel 2007 DOUG Excel Discussion (Misc queries) 0 April 2nd 09 06:10 PM
Macro Security Excel 2002 vs. 2007? Dan the Man[_2_] Excel Discussion (Misc queries) 0 August 24th 08 05:54 PM
Excel 2007 Macro Security Mary Fetsch Excel Discussion (Misc queries) 4 May 15th 08 02:10 PM


All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"