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" wrote: > [image: Boxbe] <https://www.boxbe.com/overview> Automatic Cleanup: keep > last 1 emails (mohan.pande...@gmail.com) Edit > rule<https://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&tc=13215820055_171172273>| > Delete > rule<https://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&tc=13215820055_171172273>| > Mark > important<https://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%3Dtrue&tc=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 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 >>>>>>> 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
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 > > wrote: > >> ok,that fine no problem. >> >> >> On Sat, Dec 22, 2012 at 2:41 PM, Lalit Mohan Pandey >> >> > 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 >>>>>> 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 >>>>>>> *Sender: *excel-...@googlegroups.com >>>>>>> *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) >>>>>>> *To: * >>>>>>> *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 >>>>>>> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253D&tc=13173783000_2139480533
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 > > wrote: > >> ok,that fine no problem. >> >> >> On Sat, Dec 22, 2012 at 2:41 PM, Lalit Mohan Pandey >> >> > 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 >>>>>> 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 >>>>>>> *Sender: *excel-...@googlegroups.com >>>>>>> *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) >>>>>>> *To: * >>>>>>> *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 >>>>>>> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%25
Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *
ok,that fine no problem. On Sat, Dec 22, 2012 at 2:41 PM, Lalit Mohan Pandey < mohan.pande...@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 >>>> 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 >>>>> *Sender: *excel-...@googlegroups.com >>>>> *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) >>>>> *To: * >>>>> *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 >>>>> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253D&tc=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/** >>>> 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 p
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 > > > 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 >>> 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 >>>> *Sender: * excel-...@googlegroups.com >>>> *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) >>>> *To: * >>>> *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 >>>> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253D&tc=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 <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://g
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 >> 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 >>> *Sender: * excel-...@googlegroups.com >>> *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) >>> *To: * >>> *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 >>> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253D&tc=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 <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=en<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) Jo
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 > > 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 >> *Sender: * excel-...@googlegroups.com >> *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) >> *To: * >> *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 >> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253D&tc=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-...@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=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.
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 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 > *Sender: * excel-...@googlegroups.com > *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) > *To: * > *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 > rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253D&tc=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. -- 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 * * *
Thanks Hilary On Friday, 21 December 2012 19:51:14 UTC+5:30, hilary lomotey wrote: > > Spot on Lalit. Thanks again really grateful > Sent from my BlackBerry® smartphone from Airtel Ghana > -- > *From: * Lalit Mohan Pandey > > *Date: *Fri, 21 Dec 2012 05:56:16 -0800 (PST) > *To: *> > *Cc: *> > *Subject: *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 >> *Sender: * excel-...@googlegroups.com >> *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) >> *To: * >> *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 >> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253D&tc=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 * * *
Spot on Lalit. Thanks again really grateful Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Lalit Mohan Pandey Date: Fri, 21 Dec 2012 05:56:16 To: Cc: Subject: 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 > > *Sender: * excel-...@googlegroups.com > *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) > *To: *> > *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 > rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253D&tc=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 > > *Sender: * excel-...@googlegroups.com > *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST) > *To: *> > *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 > rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D%252F8XteJTLQN4LlGLd1T25da4vfaXMulTtmyw5TXWFji6PN68RyfLc3Es%252F1GmXV5KCKDEu8PcJmcoDtiCAeRNfpEreCpw5AXLuP9PZxVMPcv3dAXwndpcRF1jcsapuouqSjnqi99Ii8%252Fgtn0fc7pT20w%253D%253D%26key%3Dau52FGIiXhr%252B6uO38alkrnKGehPfGUF7KxzTxTaCn7g%253D&tc=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. UserActivityLog.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
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 Sender: excel-macros@googlegroups.com Date: Fri, 21 Dec 2012 00:06:08 To: 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%253D&tc=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 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" > > wrote: > >> [image: Boxbe] <https://www.boxbe.com/overview> This message is >> eligible for Automatic Cleanup! (amart...@gmail.com ) Add >> cleanup >> rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D5ZjjuQIap00h%252F7%252F6XNiNXPMdG9H1C0ptdw81tQnsyH81m4qw6bBck3JhdmnvB643jhOlYcq%252FNkwYdLalP2W6EUEteP0MyhObE8fLvsqJTVBVaxJszEfSlbjkULynMBXR7SoCwDeYOD0%253D%26key%3D2lx7I3jeMqFVQMYEc7LVTCn7s3XQMp2n6GI5SZnnG84%253D&tc=13172608676_1882182346>| >> More >> info<http://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 >> >> > 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 >>>> *Sender: * excel-...@googlegroups.com >>>> *Date: *Thu, 20 Dec 2012 07:20:04 -0800 (PST) >>>> *To: * >>>> *ReplyTo: * excel-...@googlegroups.com >>>> *Cc: *excel-macros >>>> *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 >>>> 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%253D&tc=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-...@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=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 thr
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" wrote: > [image: Boxbe] <https://www.boxbe.com/overview> This message is eligible > for Automatic Cleanup! (amartak...@gmail.com) Add cleanup > rule<https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D5ZjjuQIap00h%252F7%252F6XNiNXPMdG9H1C0ptdw81tQnsyH81m4qw6bBck3JhdmnvB643jhOlYcq%252FNkwYdLalP2W6EUEteP0MyhObE8fLvsqJTVBVaxJszEfSlbjkULynMBXR7SoCwDeYOD0%253D%26key%3D2lx7I3jeMqFVQMYEc7LVTCn7s3XQMp2n6GI5SZnnG84%253D&tc=13172608676_1882182346>| > More > info<http://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 >>> *Sender: * excel-...@googlegroups.com >>> *Date: *Thu, 20 Dec 2012 07:20:04 -0800 (PST) >>> *To: * >>> *ReplyTo: * excel-...@googlegroups.com >>> *Cc: *excel-macros >>> *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 >>> 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%253D&tc=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. >> >> >> > > -- > 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
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 >> *Sender: * excel-...@googlegroups.com >> *Date: *Thu, 20 Dec 2012 07:20:04 -0800 (PST) >> *To: * >> *ReplyTo: * excel-...@googlegroups.com >> *Cc: *excel-macros >> *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 >> 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%253D&tc=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. > > > -- 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 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 > > *Sender: * excel-...@googlegroups.com > *Date: *Thu, 20 Dec 2012 07:20:04 -0800 (PST) > *To: *> > *ReplyTo: * excel-...@googlegroups.com > *Cc: *excel-macros> > *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 > 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%253D&tc=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 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 Sender: excel-macros@googlegroups.com Date: Thu, 20 Dec 2012 07:20:04 To: Reply-To: excel-macros@googlegroups.com Cc: excel-macros 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%253D&tc=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.
$$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