is there a macro that can be used to disable the insert worksheet?

i do not want users to insert any worksheet because they are always blank.

You could Protect the workbook under ToolsProtectionProtect Workbook.

Enable "Structure" option.

Or do you mean in any workbook, new or used?


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 15:13:03 -0700, jatman
wrote:

is there a macro that can be used to disable the insert worksheet?

i do not want users to insert any worksheet because they are always blank.

this works in one of the workbooks because i have the ribbon turned off so
users cannot see it. in other workbooks, the ribbon needs to be visible but
the issue would still be there - users adding empty sheets to the file.

jat


"Gord Dibben" wrote:

You could Protect the workbook under ToolsProtectionProtect Workbook.

Enable "Structure" option.

Or do you mean in any workbook, new or used?


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 15:13:03 -0700, jatman
wrote:

is there a macro that can be used to disable the insert worksheet?

i do not want users to insert any worksheet because they are always blank.