View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Log users opening the VBE?

I am using Windows XP with Office 2003.

Does anyone know if it is possible to capture the user name of any user who
opens the visual basic editor (VBE) in Excel? I know how to get the user and
computer name:

ReturnNetworkName = Environ("UserName")
ReturnComputerName = Environ("ComputerName")

But is it possible to know when the VBE is opened and then log this info? If
so, could you please post example code.

Thanks much in advance.