• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Waiting for Excel Ninja'ssssssss

Istiyak

Istiyak

Member
Hi..


There are two problems i m having.

1. I have added advance control (Calendar Control) in my form. when i m opening that form on my pc it is showing that calendar but when i m opening that form on another's pc it was blank. i think that might be going on due to advance control not available - what is the solution so user can see that calendar or any alternative for that.


And the another problem is that

2. i had unlocked Cell I9 in sheet and then protect a sheet with the only parameter "Select unlocked cell".

i have two shape on that same worksheet one is doing unlocking cell and the another is doing lock that cell.

the problem is that they are doing that job but while i m selecting I9 after locking that cell still it is going on. (Actually it doesn't because i had protected sheet only for selecting unlocked cell")

Is there any suggestion or solution....???


Waiting for Excel Ninja'ssssssss


NarayanK, Luke M, Hui.....


Regards

!$T!
 
For #1, I'd have to see it probably. My closest guess would that there is some sort of reference library that the other user does not have, but it's a wild shot.


For #2, let me see if I have this correct.

Cell I9 is unlocked

You've protected the worksheet, only option given is to select unlocked cells

There are 2 buttons that toggle sheet locking

You can still select I9 after (something), but this isn't what you want?


Could you elaborate on #2? I'm afraid I'm still confused as to what exactly you are wanting to happen. =(
 
Hi, Istiyak!


For #1 I agree with Luke M, and have a doubt: are you using the same Excel versions in both machines?


For #2 if you have a worksheet with a unique unlocked cell and two shapes and you protect it with select unlocked cell (and not with select locked cells too), it will happens that:

a) you would only be able to select that unlocked cell (I9)

b) you wouldn't be able to select shapes unless you previously unlocked them


As suggested firstly, can you please upload a sample file indicating desired behavior?


Regards!
 
Sory for delay..


Actly i was in Other Activity..


Please provide alternate option for problem #1.


I have uploaded 1 File on my Web site for problem #2.


http://www.istiyakshaikh.hpage.com > Downloads > Lock problem.xls


Plz suggest


Regards

!$T!
 
Thanks Istiyak,


Within the code, you only have a line saying to protect the sheet again. I believe you need to add a line like this:

[pre]
Code: 
ActiveSheet.EnableSelection = xlUnlockedCells
[/pre]
To limit the selection to only the unlocked cells. Code would go after the Activesheet.protect line


For the calendars, I'd suggest using the ActiveX calendar control:

http://www.rondebruin.nl/calendar.htm


Hopefully that helps.
 
HI Luke M


Thanks for your solution thats work great..... reallyyy you are Excel Ninja..?


Point #2

i already had tried that bt it is not working on another pc (Its working on My pcs where i my adding that control.)


Thanks

!$T!
 
You must log in or register to reply here.
Back
Top