View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dghelardi@gmail.com is offline
external usenet poster
 
Posts: 2
Default To protect user's privacy

I have a number of users that have to work on the same excel workbook.
Each user should have access to its own worksheet and be denied to *see* other users data.
I managed to selectively show and hide worksheets by a form asking for usn+pw in the ThisWorkbook.Workbook_Open() event.
Now I want to deny a smart user to access other user's data by VBA commands in the immediate window, so I need to deny access to VB Editor.

How can I temporary disable VB Editor?

Thanks in advance,
David