View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default Is it Possible to Deny Access except to specified

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