ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Ignore other applications" (https://www.excelbanter.com/excel-discussion-misc-queries/17436-%22ignore-other-applications%22.html)

Geoff

"Ignore other applications"
 
Hello,
I think that we all know the fix to the "I double click on an .xls file and
Excel opens but without the spreadsheet".

My Question is an extension to this in that is there a registry fix or AD
Group Policy that will stop this setting from being changed? The reason
behind this is that a user is (for whatever reason) changing this setting or
it is changing itself and I want to lock it down so that they don't raise
calls asking for me to come back and tick the dammed check box!

Thanks in advance,
Geoff

Dave Peterson

I'm not sure if you can have a preventative measure that will stop this setting
from being changed, but maybe you could add a line like this:

Application.IgnoreRemoteRequests = False

to your auto_open procedure in your personal.xls file.

There's a chance that this'll get toggled back right after it fails. But then
the user can just close that excel session and restart and if that caused the
problem. Then it'll be ok for the subsequent double-click.



Geoff wrote:

Hello,
I think that we all know the fix to the "I double click on an .xls file and
Excel opens but without the spreadsheet".

My Question is an extension to this in that is there a registry fix or AD
Group Policy that will stop this setting from being changed? The reason
behind this is that a user is (for whatever reason) changing this setting or
it is changing itself and I want to lock it down so that they don't raise
calls asking for me to come back and tick the dammed check box!

Thanks in advance,
Geoff


--

Dave Peterson


All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com