Ray,
Hopefully someone wiser than I will offer something more concrete. But I
think the best way to attack this is to look into using Group Policies.

Within Excel I think you'd have to make massive changes to every potential
workbook to look at all worksheet _Change events and see if anyone has typed
in the \\server entry into a cell. This probably a totally impractical
'solution'.

By definition, the root of a share is shared and unless you control who/what
has access to it via some Group Policy rule, I can't think of another way.
After seeing if someone here doesn't come up with a better idea in say the
next 24 hours or so, you might consider posing the question to a group
dedicated to the Server OS ... this page has a list of all MSFT product
groups: http://www.microsoft.com/communities...s/default.mspx


"Ray Pering" wrote:

How can I stop users from being able to type \\server in an excel spreadsheet
and opening the root shares on the server? I have disabled the run command in
windows which stops the command working, but it still works in excel.