Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * *

2012-12-27 Thread Hilary Lomotey
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 * * *

2012-12-26 Thread Lalit Mohan Pandey
@ 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 * * *

2012-12-26 Thread Lalit Mohan Pandey
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 * * *

2012-12-22 Thread Lalit Mohan Pandey
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 * *

2012-12-21 Thread Lalit Mohan Pandey
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 * * *

2012-12-21 Thread respuzy
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 * * *

2012-12-21 Thread Lalit Mohan Pandey

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


Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *

2012-12-21 Thread Lalit Mohan Pandey
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 * * *

2012-12-21 Thread amar takale
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

Re: $$Excel-Macros$$ Re: Vba code to Check authorised users *

2012-12-20 Thread respuzy
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 *

2012-12-20 Thread Lalit Mohan Pandey
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

2012-12-20 Thread amar takale
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 *

2012-12-20 Thread amar takale
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 * *

2012-12-20 Thread Hilary Lomotey
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