Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Licensed User - Changes on its own!
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Licensed User - Changes on its own!
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" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Licensed User - Changes on its own!
That was a guess anyway. I would suspect it uses the login name for that
message anyway. I don't see how code would affect it unless you were doing something exotic. -- Regards, Tom Ogilvy "Darren Elsom" wrote in message ... 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" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" wrote in message ... 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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I report to User A vs User B from shared data table? | Excel Discussion (Misc queries) | |||
Changing the "Licensed to" name in microsoft office | Excel Discussion (Misc queries) | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
How to: Make user click End User License Agreement acceptance | Excel Programming |