View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default ThisWorkbook.Close()

When someone opens a workbook, I will process the
Workbook_Open() function. If the user does not
match Environ("Username"), I plan to immediately close
the workbook with ThisWorkbook.Close().

This will effectively restrict users to only have access
to their own workbooks.

Does anyone see any problems with this approach?
Are there better solutions to restricting access to
workbooks? I'm curious what you think.

Rob