Re: file sharing

Tech-Archive recommends: Speed Up your PC by fixing your registry


to see who has the workbook open at any particular time click tools >
share workbook > , this will show you the usernames of people who have
it opened (the username is located in the tools > options > general
tab).

Unless you ask every one to change this username manually (only needs
to happen once) it will probably just appear as a standard default
username for everyone

There is also a remove user option in shared workbook section (not on a
network can not try it) not sure if that kicks them out


--
irishboyx
------------------------------------------------------------------------
irishboyx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32498
View this thread: http://www.excelforum.com/showthread.php?threadid=522876

.

Relevant Pages

  • Re: Limit Files via VBA not folder rights or permissions
    ... the VBA areana. ... would I get VBA to compare the list of authorized users and closethe workbook? ... "Tom Ogilvy" wrote: ... passing in a username and password to retrieve authorized ...
    (microsoft.public.excel.programming)
  • Re: vba xcel
    ... Exit Sub ... One way would be to create a userform, with username and password (you ... You would then show the form from the workbook open event. ... To make it slightly more secure, you would make the sheet holding the ...
    (microsoft.public.excel.programming)
  • Re: User-Level Sharing
    ... being creative in overcoming shortcomings in excel features. ... I would like to have User1 (with either username or password ... 'pswd1') to have access to only one specific sheet in a workbook. ... see or modify content of 'Sheet1', while User2 can modify his 'Sheet2' ...
    (microsoft.public.excel.misc)
  • Re: vba xcel
    ... One way would be to create a userform, with username and password (you ... You would then show the form from the workbook open event. ... To make it slightly more secure, you would make the sheet holding the ... password/username as "Very hidden" and lock the vba project again ...
    (microsoft.public.excel.programming)
  • Re: vba xcel
    ... i want user login to my worksheet..so how can i do that..? ... One way would be to create a userform, with username and password (you ... You would then show the form from the workbook open event. ... password/username as "Very hidden" and lock the vba project again ...
    (microsoft.public.excel.programming)