Excel runs the macro 5 seconds after it opens

ontime method.

See Applying to example properties to schedule a process to run at a specific time in the future (either at a specified time or after a specified period of time).

procedure, latesttime, schedule)

earliesttime variant type, required. Set the time when the process starts running.

procedure string type, required. Set the name of the process you want to run.

latesttime variant type, optional. The latest time for the process to start running. For example, if the LatestTime parameter is set to EarliestTime + 30, when the time is up to EarliestTime, if Microsoft Excel is not in Ready, Copy, Cut, or Find mode because other programs are running, Microsoft Excel will wait 30 seconds for the first process to end running first.

If Microsoft Excel can't get back into Ready mode within 30 seconds, this process doesn't run. If you omit the parameter, Microsoft Excel will wait until the process can be run.

schedule variant type, optional. If the value is true, a new ontime procedure is scheduled. If the value is false, the previously set procedure is cleared. The default value is true.

Illustrate. Use now + timevalue(time) to schedule a process to run after a certain period of time has elapsed (timed from now on). Use timevalue(time) to schedule a process to run only for a specified amount of time.

Example. This example sets the My Procedure procedure to run after 15 seconds, and the timer starts now.

now + timevalue("00:00:15"), "my_procedure"

This example sets my procedure to run at 5 p.m.

timevalue("17:00:00"), "my_procedure"

This example undoes the previous example's setting of ontime.

earliesttime:=timevalue("17:00:00"),procedure:="my_procedure", schedule:=false

Is it possible to control it with a for?

1. First of all, open the excel program in the computer and click [File], as shown in the figure below.

2. Then click [Options] on the left side, as shown in the following figure.

3. Then click [Clever Trust Center] in [Options], as shown in the figure below.

4. Then on the page that opens, click Trust Center Settings, as shown in the following figure.

5. Finally, click [Macro Settings] and check [Enable All Macros] in [Macro Settings]. Done, there will be no reminder to enable macros the next time you open it.

You can disable the ability to automatically open macros when Excel is opened by changing the Excel security settings.

The specific steps are as follows:

Open Excel, click the File tab, and then select Options.

In the Excel Options dialog box, pre-lease click the Trust Center tab, and then click the Trust Center Settings button.

In the Trust Center dialog box, select the Macro Settings tab.

Uncheck the Enable all macros (untrusted is not recommended) option and other options that may automatically open macros, such as Enable Access to the VBA Project Object Model and Assemblies.

Click the OK button and close all dialog boxes.

This way, Excel won't automatically open macros. If you need to use macros in a workbook, you can enable macros manually, or use the property in ** to control the execution of macros.