Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
Default Annoying macro security wont remember my settings

Is there anyway to get excel 2007 to 'remember' when you tell it to allow
the macros on a workbook, it disables them everytime and I am trying to
automate some processes which is impossible if it wont allow the macros to
run without manual intervention. i am aware of the risks etc but i am a big
boy and capable of deciding if I want a workbook (macro enabled) to be able
to run macros on opening without having to tell it every damn time! Anyone
can help would nost appreciate it.

Regards, Mark Stephens


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default Annoying macro security wont remember my settings

Hi,
It has to do with the security level of your computer change it to Mediun
and you will be able to run it

"mark Stephens" wrote:

Is there anyway to get excel 2007 to 'remember' when you tell it to allow
the macros on a workbook, it disables them everytime and I am trying to
automate some processes which is impossible if it wont allow the macros to
run without manual intervention. i am aware of the risks etc but i am a big
boy and capable of deciding if I want a workbook (macro enabled) to be able
to run macros on opening without having to tell it every damn time! Anyone
can help would nost appreciate it.

Regards, Mark Stephens



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
security med-but still wont open with macros Ian Elliott Excel Discussion (Misc queries) 1 March 17th 09 11:10 PM
macro security settings nsr_rick Excel Discussion (Misc queries) 1 February 7th 08 01:06 AM
Security Settings wgaskill Setting up and Configuration of Excel 0 August 28th 06 01:34 AM
macro security settings excel change back to low john mcmichael Excel Discussion (Misc queries) 3 April 18th 06 10:43 PM
Excel does not remember printer settings Jubbly Setting up and Configuration of Excel 0 December 12th 05 02:36 PM


All times are GMT +1. The time now is 09:02 PM.

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"