You're right Dave, the best we can do is keep honest people honest.

Mike F
"Dave Peterson" wrote in message
...
I don't think there is any workaround to the user disabling macros.

Once the workbook is opened, the user can show hidden sheets and unprotect
any
worksheet (or the workbook).

And if the user knows how to use google, the user can find a way to bypass
the
project protection.

If you really have sensitive data, don't put it into excel. If you have
to put
it into excel, don't share it with anyone you don't trust.

Mike Fogleman wrote:

Dave has a valid point. There is a work-around for those who disable
macros,
using a "Splash" sheet, if you're interested.

Mike F
"Dave Peterson" wrote in message
...
Not really.

Any suggestion will probably include macros. Macros can be disabled
and
your
information would be available to anyone who had the file.



Sean wrote:

Is it possible to deny access to open an Excel file except to
specified
user?

I assume this code as well as the user access list would go within the
ThisWorksheet. In that on opening the file, it would compare the
Computer user logged in to the list and if "Joe Bloggs" or "Joe
Public"
is listed it would allow it to open, otherwise a message "Go Away"
would appear and file would not open

Is this possible, or is it way too advanced?

Thanks

--

Dave Peterson

--

Dave Peterson