Restricting users from inserting a new worksheet in MS Excel

[zonash001]

hi all....

I m working on Ms Excel file consisting of just a single worksheet. This file needs to be circuated to other users as well so that they can add their comments on it. I want all users to work on tht particular sheet i.e. users should not be able to insert/add a new worksheet to the file. Can anyone suggest how can i restrict the users???????

 

[fredericofonseca]

Private Sub Workbook_NewSheet(ByVal Sh As Object)
Dim s As Integer
Excel.Application.DisplayAlerts = False

s = MsgBox("can not add new worksheet")
Excel.ActiveWorkbook.ActiveSheet.Delete
Excel.Application.DisplayAlerts = False
End Sub

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com