|
Setting the Autoexecute Feature
|
|
The Autoexecute feature allows you to designate regions of a worksheet for automatic execution.
|
|
|
To view the sections of a worksheet that are marked for autoexecute, you must set the worksheet interface to display markers. See Markers for more information.
|
|
|
Setting
|
|
|
1.
|
Select the region that must be automatically executed when the worksheet opens.
|
|
2.
|
From the Format menu, select Autoexecute, and then Set.
|
|
|
|
Removing
|
|
|
|
To remove the autoexecute setting in a region:
|
|
1.
|
Select the region to be cleared.
|
|
2.
|
From the Format menu, select Autoexecute, and then Clear.
|
|
•
|
To remove all autoexecution in a worksheet, select Clear All.
|
|
|
|
Repeating
|
|
|
|
To repeat autoexecution of marked groups:
|
|
•
|
From the Edit menu, select Execute, and then Repeat Autoexecute.
|
|
|
|
Warning Levels
|
|
|
|
To set warning levels for the autoexecute feature, use the Security tab in the Options dialog.
|
|
|
Download Help Document
Was this information helpful?
