Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * *
Hi This is really cool I like it very much but I have realised that when you have another excel book opened andd assuming you dont know the password and the you click on exit excel will ask you whether you want to close all tabs when you click on cancel it will.allow the user access to the login form without entering any user name or passsword are you able to go around and tighten this? Thanks On Dec 27, 2012 3:28 AM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview Automatic Cleanup: keep last 1 emails (mohan.pande...@gmail.com) Edit rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DR%252BUwJag7fzfi6CoTYSXjlP2Wi0KtKchFjLMvboDFy%252FMKzbFtWj50%252FUMiHrJyI6XyTZwYvxTRlcnS%252FZPRT3FkXFC6xF15p4e1ui7pKDbErD%252FVkqvykN1SjEcelzgUQoWAnpXwTejg4CVSlI0E5Skrng%253D%253D%26key%3DVrrMgKnmyDaAAqmY1mg5EcRwn%252FeqKSFryUtZjp66ewA%253Dtc=13215820055_171172273| Delete rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DR%252BUwJag7fzfi6CoTYSXjlP2Wi0KtKchFjLMvboDFy%252FMKzbFtWj50%252FUMiHrJyI6XyTZwYvxTRlcnS%252FZPRT3FkXFC6xF15p4e1ui7pKDbErD%252FVkqvykN1SjEcelzgUQoWAnpXwTejg4CVSlI0E5Skrng%253D%253D%26key%3DVrrMgKnmyDaAAqmY1mg5EcRwn%252FeqKSFryUtZjp66ewA%253Dtc=13215820055_171172273| Mark importanthttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DR%252BUwJag7fzfi6CoTYSXjlP2Wi0KtKchFjLMvboDFy%252FMKzbFtWj50%252FUMiHrJyI6XyTZwYvxTRlcnS%252FZPRT3FkXFC6xF15p4e1ui7pKDbErD%252FVkqvykN1SjEcelzgUQoWAnpXwTejg4CVSlI0E5Skrng%253D%253D%26key%3DVrrMgKnmyDaAAqmY1mg5EcRwn%252FeqKSFryUtZjp66ewA%253D%26emlId%3D27940304877%26important%3Dtruetc=13215820055_171172273 Hi amar Nice work . Thanks for sharing. Regards, Lalit Mohan +919711867226 On Wednesday, 26 December 2012 20:09:53 UTC+5:30, (%Allmydreams%) wrote: Hi Guys check out this you may get some more ideas to think in different On Sat, Dec 22, 2012 at 4:38 PM, amar takale amart...@gmail.com wrote: ok,that fine no problem. On Sat, Dec 22, 2012 at 2:41 PM, Lalit Mohan Pandey mohan.p...@gmail.com wrote: Hi Amar, I created this file just for the way hilary wants. Now the specifications are changing and for that matter it is not that much dynamic. Regards, Lalit Mohan On Saturday, 22 December 2012 12:32:37 UTC+5:30, amar takale wrote: Dear Lalit, but anyone can see Authorized user name.if anyone got it at least one authorized user name he can see also other user name.I want to hide Other user name or hide user Sheet if possible. Regards Amar On Sat, Dec 22, 2012 at 11:24 AM, Lalit Mohan Pandey mohan.p...@gmail.com wrote: Hi Pravin, You can also change the user access. Just login with Lalit Mohan and add user in Authorized_User sheet. Hope it will helps you. Regards, Lalit Mohan On Saturday, 22 December 2012 09:43:13 UTC+5:30, Pravin Gunjal wrote: Hi Lalit, Can we give different passwords to access this file to authorised users.. Regards Pravin Gunjal. -- Forwarded message -- From: Lalit Mohan Pandey mohan.p...@gmail.com Date: Fri, Dec 21, 2012 at 7:26 PM Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * To: excel-...@googlegroups.com Cc: res...@gmail.com Hi Hilary, Please find the revised version of the file. User name is the same as before. Let me know if it meets your expectation. Regards, Lalit Mohan On Friday, 21 December 2012 14:54:12 UTC+5:30, hilary lomotey wrote: Hi Lalit If I don't want only the name of the user to appear once the file opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the user name and time appears on the file name. The time Ȋ̝̊̅§ cool but then every person can see the user name and could log in with that user name so I wish only the name shd not appear as part of the file name. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: *Lalit Mohan Pandey mohan.p...@gmail.com *Sender: *excel-...@googlegroups.com *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) *To: *excel-...@googlegroups.com** *ReplyTo: *excel-...@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253Dtc=13173783000_2139480533| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13173783000_2139480533 -- Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *
@ amar Nice work with more features. Thanks for sharing this to us. Regards, Lalit Mohan +919711867226 On Wednesday, 26 December 2012 20:09:53 UTC+5:30, (%Allmydreams%) wrote: Hi Guys check out this you may get some more ideas to think in different On Sat, Dec 22, 2012 at 4:38 PM, amar takale amart...@gmail.comjavascript: wrote: ok,that fine no problem. On Sat, Dec 22, 2012 at 2:41 PM, Lalit Mohan Pandey mohan.p...@gmail.comjavascript: wrote: Hi Amar, I created this file just for the way hilary wants. Now the specifications are changing and for that matter it is not that much dynamic. Regards, Lalit Mohan On Saturday, 22 December 2012 12:32:37 UTC+5:30, amar takale wrote: Dear Lalit, but anyone can see Authorized user name.if anyone got it at least one authorized user name he can see also other user name.I want to hide Other user name or hide user Sheet if possible. Regards Amar On Sat, Dec 22, 2012 at 11:24 AM, Lalit Mohan Pandey mohan.p...@gmail.com wrote: Hi Pravin, You can also change the user access. Just login with Lalit Mohan and add user in Authorized_User sheet. Hope it will helps you. Regards, Lalit Mohan On Saturday, 22 December 2012 09:43:13 UTC+5:30, Pravin Gunjal wrote: Hi Lalit, Can we give different passwords to access this file to authorised users.. Regards Pravin Gunjal. -- Forwarded message -- From: Lalit Mohan Pandey mohan.p...@gmail.com Date: Fri, Dec 21, 2012 at 7:26 PM Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * To: excel-...@googlegroups.com Cc: res...@gmail.com Hi Hilary, Please find the revised version of the file. User name is the same as before. Let me know if it meets your expectation. Regards, Lalit Mohan On Friday, 21 December 2012 14:54:12 UTC+5:30, hilary lomotey wrote: Hi Lalit If I don't want only the name of the user to appear once the file opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the user name and time appears on the file name. The time Ȋ̝̊̅§ cool but then every person can see the user name and could log in with that user name so I wish only the name shd not appear as part of the file name. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: *Lalit Mohan Pandey mohan.p...@gmail.com *Sender: *excel-...@googlegroups.com *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) *To: *excel-...@googlegroups.com** *ReplyTo: *excel-...@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253Dtc=13173783000_2139480533| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13173783000_2139480533 -- Join official Facebook page of this forum @ https://www.facebook.com/ **discu**ssexcel https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.**com. Visit this group at http://groups.google.com/**group** /excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Join official Facebook page of this forum @ https://www.facebook.com/* *discussexcel https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *
Hi amar Nice work . Thanks for sharing. Regards, Lalit Mohan +919711867226 On Wednesday, 26 December 2012 20:09:53 UTC+5:30, (%Allmydreams%) wrote: Hi Guys check out this you may get some more ideas to think in different On Sat, Dec 22, 2012 at 4:38 PM, amar takale amart...@gmail.comjavascript: wrote: ok,that fine no problem. On Sat, Dec 22, 2012 at 2:41 PM, Lalit Mohan Pandey mohan.p...@gmail.comjavascript: wrote: Hi Amar, I created this file just for the way hilary wants. Now the specifications are changing and for that matter it is not that much dynamic. Regards, Lalit Mohan On Saturday, 22 December 2012 12:32:37 UTC+5:30, amar takale wrote: Dear Lalit, but anyone can see Authorized user name.if anyone got it at least one authorized user name he can see also other user name.I want to hide Other user name or hide user Sheet if possible. Regards Amar On Sat, Dec 22, 2012 at 11:24 AM, Lalit Mohan Pandey mohan.p...@gmail.com wrote: Hi Pravin, You can also change the user access. Just login with Lalit Mohan and add user in Authorized_User sheet. Hope it will helps you. Regards, Lalit Mohan On Saturday, 22 December 2012 09:43:13 UTC+5:30, Pravin Gunjal wrote: Hi Lalit, Can we give different passwords to access this file to authorised users.. Regards Pravin Gunjal. -- Forwarded message -- From: Lalit Mohan Pandey mohan.p...@gmail.com Date: Fri, Dec 21, 2012 at 7:26 PM Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * To: excel-...@googlegroups.com Cc: res...@gmail.com Hi Hilary, Please find the revised version of the file. User name is the same as before. Let me know if it meets your expectation. Regards, Lalit Mohan On Friday, 21 December 2012 14:54:12 UTC+5:30, hilary lomotey wrote: Hi Lalit If I don't want only the name of the user to appear once the file opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the user name and time appears on the file name. The time Ȋ̝̊̅§ cool but then every person can see the user name and could log in with that user name so I wish only the name shd not appear as part of the file name. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: *Lalit Mohan Pandey mohan.p...@gmail.com *Sender: *excel-...@googlegroups.com *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) *To: *excel-...@googlegroups.com** *ReplyTo: *excel-...@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253Dtc=13173783000_2139480533| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13173783000_2139480533 -- Join official Facebook page of this forum @ https://www.facebook.com/ **discu**ssexcel https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.**com. Visit this group at http://groups.google.com/**group** /excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Join official Facebook page of this forum @ https://www.facebook.com/* *discussexcel https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *
Hi Amar, I created this file just for the way hilary wants. Now the specifications are changing and for that matter it is not that much dynamic. Regards, Lalit Mohan On Saturday, 22 December 2012 12:32:37 UTC+5:30, amar takale wrote: Dear Lalit, but anyone can see Authorized user name.if anyone got it at least one authorized user name he can see also other user name.I want to hide Other user name or hide user Sheet if possible. Regards Amar On Sat, Dec 22, 2012 at 11:24 AM, Lalit Mohan Pandey mohan.p...@gmail.comjavascript: wrote: Hi Pravin, You can also change the user access. Just login with Lalit Mohan and add user in Authorized_User sheet. Hope it will helps you. Regards, Lalit Mohan On Saturday, 22 December 2012 09:43:13 UTC+5:30, Pravin Gunjal wrote: Hi Lalit, Can we give different passwords to access this file to authorised users.. Regards Pravin Gunjal. -- Forwarded message -- From: Lalit Mohan Pandey mohan.p...@gmail.com Date: Fri, Dec 21, 2012 at 7:26 PM Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * To: excel-...@googlegroups.com Cc: res...@gmail.com Hi Hilary, Please find the revised version of the file. User name is the same as before. Let me know if it meets your expectation. Regards, Lalit Mohan On Friday, 21 December 2012 14:54:12 UTC+5:30, hilary lomotey wrote: Hi Lalit If I don't want only the name of the user to appear once the file opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the user name and time appears on the file name. The time Ȋ̝̊̅§ cool but then every person can see the user name and could log in with that user name so I wish only the name shd not appear as part of the file name. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Lalit Mohan Pandey mohan.p...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253Dtc=13173783000_2139480533| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13173783000_2139480533 -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * *
Hi Hialary, Thanks you so much. and merry christmas to you too. Regards, Lalit Mohan On Friday, 21 December 2012 12:14:02 UTC+5:30, hilary lomotey wrote: Hi lalit This solution is beyond my expectation. Great work thanks a million and a merry christmas On Dec 21, 2012 4:42 AM, amar takale amart...@gmail.com javascript: wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (amart...@gmail.com javascript:) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D5ZjjuQIap00h%252F7%252F6XNiNXPMdG9H1C0ptdw81tQnsyH81m4qw6bBck3JhdmnvB643jhOlYcq%252FNkwYdLalP2W6EUEteP0MyhObE8fLvsqJTVBVaxJszEfSlbjkULynMBXR7SoCwDeYOD0%253D%26key%3D2lx7I3jeMqFVQMYEc7LVTCn7s3XQMp2n6GI5SZnnG84%253Dtc=13172608676_1882182346| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13172608676_1882182346 Hi Dear, Thanks very much .I got code Authorised user .It is useful me in future On Fri, Dec 21, 2012 at 8:39 AM, Lalit Mohan Pandey mohan.p...@gmail.comjavascript: wrote: Hi Hilary, Sorry for that, User name is Lalit Mohan or a whatever you want. and you can also change the user name in Authorised user sheet. Regards, Lalit Mohan On Friday, 21 December 2012 00:33:55 UTC+5:30, hilary lomotey wrote: Hi Lalit looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ it but I don't know the user name to type so I haven't been able to access this. Kindly provide the user name. But it looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ exactly what I want. Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Lalit Mohan Pandey mohan.p...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Thu, 20 Dec 2012 07:20:04 -0800 (PST) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Cc: *excel-macrosEXCEL-...@**googlegroups.com *Subject: *$$Excel-Macros$$ Re: Vba code to Check authorised users * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DtF4MQIKNtgo4Q7D0l8cASqNpuYJsw%252Fu83%252FmZqFngi1PBTlxAvaWDQJIjpn4UiKuDQylKoQaMVN7QkSvXQ2l4dBDvdZ1mqb1Rc5kdXjW9U%252FAq6L%252FUCd%252BXKZDXfyaXJ28n9JkaBA5iJgF0gVDzGD6wEw%253D%253D%26key%3D0BCS6OGHPq9HhCGrAhZRQyrbD0cxDtBm17EisDMZFog%253Dtc=13167949549_680277595| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13167949549_680277595 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *
Hi Lalit If I don't want only the name of the user to appear once the file opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the user name and time appears on the file name. The time Ȋ̝̊̅§ cool but then every person can see the user name and could log in with that user name so I wish only the name shd not appear as part of the file name. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Lalit Mohan Pandey mohan.pande...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 21 Dec 2012 00:06:08 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * This message is eligible for Automatic Cleanup! (mohan.pande...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253Dtc=13173783000_2139480533 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13173783000_2139480533 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *
Hi Hilary, Please find the revised version of the file. User name is the same as before. Let me know if it meets your expectation. Regards, Lalit Mohan On Friday, 21 December 2012 14:54:12 UTC+5:30, hilary lomotey wrote: Hi Lalit If I don't want only the name of the user to appear once the file opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the user name and time appears on the file name. The time Ȋ̝̊̅§ cool but then every person can see the user name and could log in with that user name so I wish only the name shd not appear as part of the file name. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Lalit Mohan Pandey mohan.p...@gmail.com javascript: *Sender: * excel-...@googlegroups.com javascript: *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) *To: *excel-...@googlegroups.com javascript: *ReplyTo: * excel-...@googlegroups.com javascript: *Subject: *Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com javascript:) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253Dtc=13173783000_2139480533| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13173783000_2139480533 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. UserActivityLog.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Fwd: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *
Hi Lalit, Can we give different passwords to access this file to authorised users.. Regards Pravin Gunjal. -- Forwarded message -- From: Lalit Mohan Pandey mohan.pande...@gmail.com Date: Fri, Dec 21, 2012 at 7:26 PM Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * To: excel-macros@googlegroups.com Cc: resp...@gmail.com Hi Hilary, Please find the revised version of the file. User name is the same as before. Let me know if it meets your expectation. Regards, Lalit Mohan On Friday, 21 December 2012 14:54:12 UTC+5:30, hilary lomotey wrote: Hi Lalit If I don't want only the name of the user to appear once the file opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the user name and time appears on the file name. The time Ȋ̝̊̅§ cool but then every person can see the user name and could log in with that user name so I wish only the name shd not appear as part of the file name. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Lalit Mohan Pandey mohan.p...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253Dtc=13173783000_2139480533| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13173783000_2139480533 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. UserActivityLog.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *
Hi Pravin, You can also change the user access. Just login with Lalit Mohan and add user in Authorized_User sheet. Hope it will helps you. Regards, Lalit Mohan On Saturday, 22 December 2012 09:43:13 UTC+5:30, Pravin Gunjal wrote: Hi Lalit, Can we give different passwords to access this file to authorised users.. Regards Pravin Gunjal. -- Forwarded message -- From: Lalit Mohan Pandey mohan.p...@gmail.com javascript: Date: Fri, Dec 21, 2012 at 7:26 PM Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * To: excel-...@googlegroups.com javascript: Cc: res...@gmail.com javascript: Hi Hilary, Please find the revised version of the file. User name is the same as before. Let me know if it meets your expectation. Regards, Lalit Mohan On Friday, 21 December 2012 14:54:12 UTC+5:30, hilary lomotey wrote: Hi Lalit If I don't want only the name of the user to appear once the file opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the user name and time appears on the file name. The time Ȋ̝̊̅§ cool but then every person can see the user name and could log in with that user name so I wish only the name shd not appear as part of the file name. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Lalit Mohan Pandey mohan.p...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253Dtc=13173783000_2139480533| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13173783000_2139480533 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *
Dear Lalit, but anyone can see Authorized user name.if anyone got it at least one authorized user name he can see also other user name.I want to hide Other user name or hide user Sheet if possible. Regards Amar On Sat, Dec 22, 2012 at 11:24 AM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Hi Pravin, You can also change the user access. Just login with Lalit Mohan and add user in Authorized_User sheet. Hope it will helps you. Regards, Lalit Mohan On Saturday, 22 December 2012 09:43:13 UTC+5:30, Pravin Gunjal wrote: Hi Lalit, Can we give different passwords to access this file to authorised users.. Regards Pravin Gunjal. -- Forwarded message -- From: Lalit Mohan Pandey mohan.p...@gmail.com Date: Fri, Dec 21, 2012 at 7:26 PM Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * To: excel-...@googlegroups.com Cc: res...@gmail.com Hi Hilary, Please find the revised version of the file. User name is the same as before. Let me know if it meets your expectation. Regards, Lalit Mohan On Friday, 21 December 2012 14:54:12 UTC+5:30, hilary lomotey wrote: Hi Lalit If I don't want only the name of the user to appear once the file opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the user name and time appears on the file name. The time Ȋ̝̊̅§ cool but then every person can see the user name and could log in with that user name so I wish only the name shd not appear as part of the file name. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Lalit Mohan Pandey mohan.p...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253Dtc=13173783000_2139480533| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13173783000_2139480533 -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post
$$Excel-Macros$$ Re: Vba code to Check authorised users
Hi Hilary, Please find the attached file. Hope it meets your expectation. Regards, Lalit mohan On Thursday, 20 December 2012 16:41:58 UTC+5:30, hilary lomotey wrote: Hi experts I want to keep a log of people and time as well as action ie open workbook and close workbk of people who use an excel template . For instance if I have say a list of 5 people authorised people when the workbook opens it shd request for the name of person eg a userform with a name if the name doesnt correspond with the authorized users then workbook shd close at the same time if the right person opens the wkbk then the log shd indicate the time date person and action ie wkbook open or close . Is there a vba code to do this thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. UserActivityLog.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users *
Hi Lalit looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ it but I don't know the user name to type so I haven't been able to access this. Kindly provide the user name. But it looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ exactly what I want. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Lalit Mohan Pandey mohan.pande...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 20 Dec 2012 07:20:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: excel-macrosEXCEL-MACROS@googlegroups.com Subject: $$Excel-Macros$$ Re: Vba code to Check authorised users * This message is eligible for Automatic Cleanup! (mohan.pande...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DtF4MQIKNtgo4Q7D0l8cASqNpuYJsw%252Fu83%252FmZqFngi1PBTlxAvaWDQJIjpn4UiKuDQylKoQaMVN7QkSvXQ2l4dBDvdZ1mqb1Rc5kdXjW9U%252FAq6L%252FUCd%252BXKZDXfyaXJ28n9JkaBA5iJgF0gVDzGD6wEw%253D%253D%26key%3D0BCS6OGHPq9HhCGrAhZRQyrbD0cxDtBm17EisDMZFog%253Dtc=13167949549_680277595 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13167949549_680277595 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users *
Hi Hilary, Sorry for that, User name is Lalit Mohan or a whatever you want. and you can also change the user name in Authorised user sheet. Regards, Lalit Mohan On Friday, 21 December 2012 00:33:55 UTC+5:30, hilary lomotey wrote: Hi Lalit looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ it but I don't know the user name to type so I haven't been able to access this. Kindly provide the user name. But it looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ exactly what I want. Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Lalit Mohan Pandey mohan.p...@gmail.com javascript: *Sender: * excel-...@googlegroups.com javascript: *Date: *Thu, 20 Dec 2012 07:20:04 -0800 (PST) *To: *excel-...@googlegroups.com javascript: *ReplyTo: * excel-...@googlegroups.com javascript: *Cc: *excel-macrosexcel-...@googlegroups.com javascript: *Subject: *$$Excel-Macros$$ Re: Vba code to Check authorised users * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com javascript:) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DtF4MQIKNtgo4Q7D0l8cASqNpuYJsw%252Fu83%252FmZqFngi1PBTlxAvaWDQJIjpn4UiKuDQylKoQaMVN7QkSvXQ2l4dBDvdZ1mqb1Rc5kdXjW9U%252FAq6L%252FUCd%252BXKZDXfyaXJ28n9JkaBA5iJgF0gVDzGD6wEw%253D%253D%26key%3D0BCS6OGHPq9HhCGrAhZRQyrbD0cxDtBm17EisDMZFog%253Dtc=13167949549_680277595| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13167949549_680277595 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users
Hi Dear, Nice CreativityThanks to sharing with us But how to do it if I check it example which name I put in authorized person,how to look VBA code.Can I get this code. Regards Amar On Thu, Dec 20, 2012 at 8:50 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: person and action ie wkbook open or close . Is there a vba code -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users *
Hi Dear, Thanks very much .I got code Authorised user .It is useful me in future On Fri, Dec 21, 2012 at 8:39 AM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Hi Hilary, Sorry for that, User name is Lalit Mohan or a whatever you want. and you can also change the user name in Authorised user sheet. Regards, Lalit Mohan On Friday, 21 December 2012 00:33:55 UTC+5:30, hilary lomotey wrote: Hi Lalit looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ it but I don't know the user name to type so I haven't been able to access this. Kindly provide the user name. But it looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ exactly what I want. Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Lalit Mohan Pandey mohan.p...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Thu, 20 Dec 2012 07:20:04 -0800 (PST) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Cc: *excel-macrosEXCEL-...@**googlegroups.com *Subject: *$$Excel-Macros$$ Re: Vba code to Check authorised users * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DtF4MQIKNtgo4Q7D0l8cASqNpuYJsw%252Fu83%252FmZqFngi1PBTlxAvaWDQJIjpn4UiKuDQylKoQaMVN7QkSvXQ2l4dBDvdZ1mqb1Rc5kdXjW9U%252FAq6L%252FUCd%252BXKZDXfyaXJ28n9JkaBA5iJgF0gVDzGD6wEw%253D%253D%26key%3D0BCS6OGHPq9HhCGrAhZRQyrbD0cxDtBm17EisDMZFog%253Dtc=13167949549_680277595| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13167949549_680277595 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * *
Hi lalit This solution is beyond my expectation. Great work thanks a million and a merry christmas On Dec 21, 2012 4:42 AM, amar takale amartak...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (amartak...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D5ZjjuQIap00h%252F7%252F6XNiNXPMdG9H1C0ptdw81tQnsyH81m4qw6bBck3JhdmnvB643jhOlYcq%252FNkwYdLalP2W6EUEteP0MyhObE8fLvsqJTVBVaxJszEfSlbjkULynMBXR7SoCwDeYOD0%253D%26key%3D2lx7I3jeMqFVQMYEc7LVTCn7s3XQMp2n6GI5SZnnG84%253Dtc=13172608676_1882182346| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13172608676_1882182346 Hi Dear, Thanks very much .I got code Authorised user .It is useful me in future On Fri, Dec 21, 2012 at 8:39 AM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Hi Hilary, Sorry for that, User name is Lalit Mohan or a whatever you want. and you can also change the user name in Authorised user sheet. Regards, Lalit Mohan On Friday, 21 December 2012 00:33:55 UTC+5:30, hilary lomotey wrote: Hi Lalit looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ it but I don't know the user name to type so I haven't been able to access this. Kindly provide the user name. But it looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ exactly what I want. Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * Lalit Mohan Pandey mohan.p...@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Thu, 20 Dec 2012 07:20:04 -0800 (PST) *To: *excel-...@googlegroups.com** *ReplyTo: * excel-...@googlegroups.com *Cc: *excel-macrosEXCEL-...@**googlegroups.com *Subject: *$$Excel-Macros$$ Re: Vba code to Check authorised users * [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DtF4MQIKNtgo4Q7D0l8cASqNpuYJsw%252Fu83%252FmZqFngi1PBTlxAvaWDQJIjpn4UiKuDQylKoQaMVN7QkSvXQ2l4dBDvdZ1mqb1Rc5kdXjW9U%252FAq6L%252FUCd%252BXKZDXfyaXJ28n9JkaBA5iJgF0gVDzGD6wEw%253D%253D%26key%3D0BCS6OGHPq9HhCGrAhZRQyrbD0cxDtBm17EisDMZFog%253Dtc=13167949549_680277595| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13167949549_680277595 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing