hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

**santosh226001** · 07-18-2013, 01:19 AM

hELLO SIR

I m facing a problem in my project..which is following..

I have a project workbook (d2iproject) in this file 3 sheet (road details, Prarup-1 & Prarup-2)
RoadDetail sheet link with above 2 sheet.. in project file when we work & press Colum J "Y" then after Colum "K" choose option ... code line show that cell is protected... (as per code we want to unprotected with conditional)

But if we copy above 3 sheets in a new workbook then my code work perfectly as per my requirement

Sir pls test or check my code & also tell me where i m mistak. (file is enclosed)

Thanks in advance.. (Sorry sir i m week in English hope u understand what i want to say)

**santosh226001** · 07-18-2013, 07:02 AM

Forum expert & guru's pls help me for my code... y Roaddetail sheet is not working in project workbook... whenever same code enable sheet work fine outside this project file...

**santosh226001** · 07-31-2013, 09:46 AM

Forum Expert'/ Guru's pls help me above problem.. i try lot of time but can't success

**santosh226001** · 08-01-2013, 01:46 AM

Sir i m using follwing code in my file pls suggest me where i m mistake so that cell show that is protected

Please Login or Register  to view this content.

in above code red color part not working properly as per defin in instruction..

Thanks in advance

**santosh226001** · 08-02-2013, 06:24 AM

hello

Any one can pls help that why my above code not working in my project workbook & same code work in other workbook fine..

pls help me complete my project..

Thanks in advance

**:) Sixthsense :)** · 08-05-2013, 01:33 AM

When I download and Open your file it seems to be little bit corrupted.

When opening the file click the small drop down in the Open Button and select Open and Repair and the file and the code is working fine for me.

Please check and confirm

**santosh226001** · 08-05-2013, 02:04 AM

Hello Sir..

Thanks for showing intrest in my project
sir i have requested you to pls attach that file which one u repaird...

Cos we also again download same file & open and repair... but same problem still same

problem is this

when we choose Y in Colum J then Colum K Show that is protected...

As per code we unproted

Thanksx

**:) Sixthsense :)** · 08-05-2013, 03:42 AM

Please provide the password of that sheet for testing purpose.

**santosh226001** · 08-05-2013, 03:45 AM

sir password is also mention in vba code i.e. 123 in road details sheet

Please Login or Register  to view this content.

**:) Sixthsense :)** · 08-05-2013, 04:48 AM

Just remove the password for road details sheet.

Press Alt+F11 and press Ctrl+G to get the Immediate window and in immediate window paste the below code

Please Login or Register  to view this content.

and give enter. Now goto road details sheet and do the selection which will work fine.

**santosh226001** · 08-05-2013, 05:03 AM

Sir guide me that we remove password through unprotected sheet or..

remove password line from VBA code???

Please Login or Register  to view this content.

**:) Sixthsense :)** · 08-05-2013, 05:44 AM

I believe CURRENTLY the sheet is not protected with a password in code by enabling the UserInterfaceOnly:=True.

In Manual sheet protection we don't have the option to TURN ON UserInterfaceOnly while protecting the sheet.

So you just unprotect the sheet manually then apply the protection via vba with the help of Immediate Window as I suggested in Post #10 and after applying the protection try to change the cell values of the sheet and check.

**santosh226001** · 08-05-2013, 06:51 AM

Sixthsense sir we do as per instrucion in post 10# (also enclosing my image shot file that what i m doing) but sir problem is still same one row data unprotect but after that again lock..

Sir surprising thing that if we copy thease 3 sheet (Road Details, Prarup-1 & Prarup-2) in new workbook then they work perfectly as per my requirement...

Sir one again thanks for ur giving valuable time for this problem...

**santosh226001** · 08-06-2013, 12:44 AM

Sixthsense

Sir is trying to help ...

any other one can help/suggest me for my above problem????

**nilem** · 08-06-2013, 05:22 AM

Hi Santosh
Re PM
a very large project... but try
(see module "ThisWorkbook" and "road details")

**santosh226001** · 08-06-2013, 06:19 AM

Hello Nilem sir thanks for ur reply..

sir ur provided file work as per my requirement... thanks a lot..

u r such a god for me .. who help to make my this project..

Sir will u help me to understand following Red color line to understand me these code....

Please Login or Register  to view this content.

Thanks

**nilem** · 08-06-2013, 06:53 AM

oops, there are extra lines in this part of the code
so should be correctly

Please Login or Register  to view this content.

hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

LinkBack

Thread Tools

Rate This Thread

Display

hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Re: hELP FOR MY PROJECT (IN PROJECT SHEET CODE NOT WORK,, OUTSIDE THAT CODE WORK)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Function that concatenates multiple sub-project descriptions based on project code

Work-date project

Cross-referencing help for work project

If i entered any project code in sheet2 display all data of that project

[SOLVED] Beginner needs help w/first work project

Bookmarks

Bookmarks

Posting Permissions