Hello

How can i disable (or invisible) the checkbox "ignore other applications" in
Tools - Options... - General ?
I set this box to "true" from my excel application and nobody else should be
able to set it back to "false".

thanks for the help
s.wiederkehr

Maybe just resetting it each time you start excel would be enough.

Add a line like this to your personal.xls auto_open (or workbook_open)
procedu

Application.IgnoreRemoteRequests = True

If you don't have a personal.xls, you can create a new one and save it to your
xlstart folder.

That code could look like this:


Option Explicit
Sub auto_open()
Application.IgnoreRemoteRequests = True
ThisWorkbook.Close savechanges:=False
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


swiederkehr wrote:

Hello

How can i disable (or invisible) the checkbox "ignore other applications" in
Tools - Options... - General ?
I set this box to "true" from my excel application and nobody else should be
able to set it back to "false".

thanks for the help
s.wiederkehr

--

Dave Peterson