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
|