View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default disable Insert Worksheet

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.