Hide or deny a user to use alterantive 1

[nfpk]

Hi!
Is it possible to deny a user to use the alternative dialogbox in the Toolsmenu?
I have created a workbook where I don´t want a user to see the row numbers or column headers, I protect the sheet but it is still possible for the user to change all the options in Excel window with the alternative dialog in the Toolsmenu. It must be possible to protect this. Anyone know how?
nfpk

 

[luceze]

Although I am not an expert at this by any means, I have had some luck using the commandbars function in the on open event of a workbook.

With this line I can turn off options in the tools menu when the workbook opens.

**************************
Private Sub Workbook_Open()

Application.CommandBars("tools&quot.Controls(17).Enabled = False

End Sub
**************************

You might have to play with the number 17 depending if you have any custom items in your tools menu.

Note: I use this with Excel 2002.