Dynamically allowing/disallowing user sheet insert.

[PapaBear56]

I am trying to develop a Excel 2007 application where I want to control when-where-and how a new worksheet is inserted. I have controls in the application that inserts worksheets into the workbook that follow specific parameters and I want to prevent the user from being able to insert a sheet in any way other than that the application controls.

I know how to completely prevent the user from inserting sheets, but that method is also preventing my code from doing it.

Any help would be greatly appreciated.

Thanks,
PapaBear56 a.k.a. Mike

[mdmackillop]

Can you post your sheet insertion code? Workbook protection will need to be incorporated into it.