Re: Licensed User - Changes on its own!

Tom,

Having checked the code again, I have noticed that when the new workbook is
open, I have specified that the user name is my own name.

I assume this has caused the problem and that my name must be entered into
the registry for microsoft applications.

Thanks, for your help.





"Darren Elsom" <darren@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:e4Qmp9zRFHA.3336@xxxxxxxxxxxxxxxxxxxxxxx
>
> No, I dont believe so.
>
> I do however, use the code to open a new workbook and transfer deails from
> the original to the new via copy/paste.
>
> Regards,
>
>
> Darren.
>
>
> "Tom Ogilvy" <twogilvy@xxxxxxx> wrote in message
> news:eulO9zzRFHA.3120@xxxxxxxxxxxxxxxxxxxxxxx
>> 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" <darren@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:OL%23I8ozRFHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
>>> A number of users that are currently using a spread*** 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 spread*** 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.
>>>
>>>
>>
>>
>
>


.