Re: $$Excel-Macros$$ Masking Password in input box * *

2012-10-28 Thread Hilary Lomotey
Thanks Ashish The option you have provided makes it impossible to access other sheet when the workbook is opened What I request exactly is amongst the three worksheet I only want say w sheet 2 to be locked when the workbook is opened however if you enter the password it should allow access all the

Re: $$Excel-Macros$$ Masking Password in input box * * *

2012-10-26 Thread respuzy
Airtel Ghana -Original Message- From: Paul Schreiner Sender: excel-macros@googlegroups.com Date: Thu, 25 Oct 2012 10:09:53 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Masking Password in input box * * * This message is eligible for Automatic Cleanup

Re: $$Excel-Macros$$ Masking Password in input box * *

2012-10-25 Thread Paul Schreiner
y Lomotey To: excel-macros@googlegroups.com Sent: Thu, October 25, 2012 12:49:11 PM Subject: Re: $$Excel-Macros$$ Masking Password in input box * * Thanks Ashish, really grateful for your assistance but the problem is my vba is still fundamental , i tried linking what u sent to me to the code

Re: $$Excel-Macros$$ Masking Password in input box *

2012-10-24 Thread Hilary Lomotey
Hello Again, Pls how to i combine the code below here to the code in this attached workbook (got it on the web) to achieve my desired results. Desired results being being able to password protect a sheet worksheet (just as the code below is doing only that its not masking the password). The attach

Re: $$Excel-Macros$$ Masking Password in input box *

2012-10-24 Thread Hilary Lomotey
Hello Pls see attatched file as example On Wed, Oct 24, 2012 at 4:45 PM, Hilary Lomotey wrote: > Thanks Ashish, > > one question do i paste the same code in the userform? how do i go about > it pls > > On Wed, Oct 24, 2012 at 3:17 PM, ashish koul wrote: > >> [image: Boxbe]

Re: $$Excel-Macros$$ Masking Password in input box *

2012-10-24 Thread Hilary Lomotey
Thanks Ashish, one question do i paste the same code in the userform? how do i go about it pls On Wed, Oct 24, 2012 at 3:17 PM, ashish koul wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Masking Password in input box

2012-10-24 Thread ashish koul
use userform and textbox instead of msgbox and in text box choose * in passwordchar [image: Inline image 1] On Wed, Oct 24, 2012 at 8:44 PM, Hilary Lomotey wrote: > Hi Exxperts > > I got this code to protect a worksheet, which was exactly what i was > looking for only that entering the pass