Thanks :)
Its working well. . .. . . .
Thanks alot to all supportive members
Regds,
Manish
On Dec 31 2010, 5:02 am, ashish koul wrote:
> hi manish
>
> check this link you can hide all the sheets and make user to click on
> enable macro to make that sheet visible.
>
> http://www.vbaexpr
hi manish
check this link you can hide all the sheets and make user to click on
enable macro to make that sheet visible.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=379
to insert row write in code to to unprotect sheet and then protect it again.
On Thu, Dec 30, 2010 at 4:25 PM, Mani
Again, unless i will not enable the macro, i can change in the locked
cell :( :(
How can I enable the macro automatically, if the user open the xl
file. I hope my requirement is clear and hope such option is available
in VBA.
Regds,
Manish
--
---
Thanks once again.. :) concept clear..
Again need more value addition...
this code is working fine. I am not be able to insert the row,
once macro protect the sheet. I want only insert the row, even after
the protection of the worksheet
Pls suggest
Thanks boss
Regds,
Man
**Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
'target.column =3 because column c is no 3 column
'you can change password ashish and choose your own
ActiveSheet.Unprotect Password:="ashish"
If Not IsEmpty(Target.Value) And Target.Value = "Yes" Then
Cells(Targe
b is column no 2
g is column no 7
target.row will select the row
On Thu, Dec 30, 2010 at 1:39 PM, ashish koul wrote:
> **Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Column = 1 Then
>
> 'target.column =3 because column c is no 3 column
>
> 'you can change password ashish a
Thanks Ashish,
This is perfect as i want.
I need some more help, If i want to lock only column B to G (not want
to lock entire row) than what will the code.
I want to understand the diff in codes. :)
Thanks once again for your help.
Regds,
Manish
On Dec 30, 10:31 am, ashish koul wrote:
> Priva
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
'target.column =3 because column c is no 3 column
'you can change password ashish and choose your own
ActiveSheet.Unprotect Password:="ashish"
If Not IsEmpty(Target.Value) And Target.Value = "Yes" Then
Rows(Target.Row
Any help/suggestion ???
Thanks,
Manish
On Dec 29, 3:03 pm, Manish Pansari wrote:
> Dear EE,
>
> Is it possible to lock the entire row/selected cell based on condition
> in particular Cell.
> for example, I want to lock the row based on value in column A. If
> macro found value "yes" in cell A1 &