ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro Execution, Part Duo (https://www.excelbanter.com/excel-discussion-misc-queries/150010-macro-execution-part-duo.html)

C Brandt

Macro Execution, Part Duo
 
I found the Scheduler in the control panel and it is very straight forward
and easy to use, but when it executes the spread sheet, I get the message
that the spreadsheet contains macros...... and asks if I want to continue.
Is there a way around this issue?

Also, can I put something in the macro that closes down the spreadsheet when
the macro has completed it's task?

So close, yet so far away...

Craig



Pete_UK

Macro Execution, Part Duo
 
You could set your security level to low (not really recommended, but
if you are the only one writing macros for the machine you might want
to risk it ...)

Hope this helps.

Pete


On Jul 12, 10:32 pm, "C Brandt" wrote:
I found the Scheduler in the control panel and it is very straight forward
and easy to use, but when it executes the spread sheet, I get the message
that the spreadsheet contains macros...... and asks if I want to continue.
Is there a way around this issue?

Also, can I put something in the macro that closes down the spreadsheet when
the macro has completed it's task?

So close, yet so far away...

Craig





All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com