LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Automating the depressing of ENABLE MACROS popup

I have a series of macros built into Excel that I would
like to put into a scheduler to run over night. However,
I can not get the macro to default to ENABLE MACROS,
thereofre someone needs to manually depress this button
to launch the Spreadsheet. I am aware that I cna chage
the level of security but for one reason or another this
is no good. Surely there is some VBA that can do this
for me?
Any help appreciated!
Cheers
 
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
Automating change via popup to a column of numbers Colin Hayes Excel Worksheet Functions 0 May 28th 09 02:59 PM
How do I stop the popup "Enable/Disable Automatic Refresh"? RiverGuy Excel Discussion (Misc queries) 0 May 10th 09 03:38 PM
Automating Excel (Macros) Outlook Convert New Users to Excel 5 June 11th 07 10:13 PM
Automating swnding mails using macros on Excel. Brinda Excel Worksheet Functions 1 March 13th 06 03:03 PM
Suppress the Disable Macros / Enable Macros Dialog Shoji Karai Excel Programming 5 September 24th 03 03:10 AM


All times are GMT +1. The time now is 12:15 PM.

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

About Us

"It's about Microsoft Excel"