View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Licensed User - Changes on its own!

Do you use application.Username in the code?

I suspect you are trying to us it as a comparison and it is being
interpreted as an assignment.

--
Regards,
Tom Ogilvy


"Darren Elsom" wrote in message
...
A number of users that are currently using a spreadsheet I have developed
have found that when launching ANY Microsoft Office product, the licensed
user has now changed to my name.

This also means that when a user is in the workbook on a shared

area/drive,
and a second user attempts to open the workbook - the box stating that

the
'file is in use by' has my name in and not the users.


The spreadsheet uses VBA to create a tool bar on the fly, deleting it when
the workbook closes. None of my code directly writes to the registry.

Are there any known issues that could cause this problem?


Thanks in advance for any help you can provide me with.


Darren.