AX1453

Disabling drilling for a sheet

By default, the Drill button in the File Options group is enabled for all sheets that are defined on the file's Control Sheet. If a user clicks the Drill button while their cursor is on a row that is not eligible for drilling, then the Drill menu displays a message to that effect.

You may have sheets in a file where you never want the Drill button to be enabled, or you may only want it to be enabled for certain audiences. In this case, you can disable drilling for the sheet by setting the Enable Drilling option to Off (either directly, or by using a formula).

If drilling is disabled for a sheet, then the Drill button on the ribbon is disabled when that sheet is active. Users can switch between sheets that are enabled or disabled for drilling, and the button will become enabled or disabled as appropriate. If Axiom Double-Click is enabled for a sheet where drilling is disabled (or if Double-click to drill is enabled for a custom drill), then double-click drilling will be disabled as well.