Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 211
Default XL 2007 - Macros won't run when security configured to allow macr

Hi,

I'm creating my first XL 2007 VBA project -- yesterday I was able to develop
and run macros. I rebooted this morning, and now I get the error indicating I
need to enable macros and re-open the workbook. The workbook does not have a
password (referenced in a post 7/17/2008).

I've double-checked the Macro settings -- which I haven't changed -- and the
are disabled with notifcation, and the message bar is configured to show
warnings. I'm not getting any warnings, and I'm unable to run the macros.

Any thoughts?

Regards,

Gordon
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,276
Default XL 2007 - Macros won't run when security configured to allow macr

Hi,
workbook has to be saved as macro enable .xslm

"Gordon" wrote:

Hi,

I'm creating my first XL 2007 VBA project -- yesterday I was able to develop
and run macros. I rebooted this morning, and now I get the error indicating I
need to enable macros and re-open the workbook. The workbook does not have a
password (referenced in a post 7/17/2008).

I've double-checked the Macro settings -- which I haven't changed -- and the
are disabled with notifcation, and the message bar is configured to show
warnings. I'm not getting any warnings, and I'm unable to run the macros.

Any thoughts?

Regards,

Gordon

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 100
Default XL 2007 - Macros won't run when security configured to allow

Is it not xlsm?
--
A. Ch. Eirinberg


"Eduardo" wrote:

Hi,
workbook has to be saved as macro enable .xslm

"Gordon" wrote:

Hi,

I'm creating my first XL 2007 VBA project -- yesterday I was able to develop
and run macros. I rebooted this morning, and now I get the error indicating I
need to enable macros and re-open the workbook. The workbook does not have a
password (referenced in a post 7/17/2008).

I've double-checked the Macro settings -- which I haven't changed -- and the
are disabled with notifcation, and the message bar is configured to show
warnings. I'm not getting any warnings, and I'm unable to run the macros.

Any thoughts?

Regards,

Gordon

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
XL 2007 - Macros won't run when security configured to allow macr Gordon[_2_] Excel Programming 0 May 21st 09 04:07 PM
Security Alert Macros have been disabled - Excel 2007 Heera[_2_] Excel Programming 4 February 11th 09 09:37 PM
Security Alert Macros have been disabled - Excel 2007 Heera[_2_] Excel Programming 1 February 11th 09 06:39 PM
Macros security AiadTarik Excel Programming 2 November 5th 08 08:31 AM
Programmatically opening workbooks in macros brings up Enable Macr Barb Reinhardt Excel Programming 14 July 15th 08 01:32 PM


All times are GMT +1. The time now is 09:44 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"