Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable excell sheet cell from VB Script
Hai guys, i want to disable the cell(making user not to enter the data in particular cell) from VB Script(here i have to use VB Script becoz have to disable this cell based on som other conditions.). plz help me... Thanks & regards, Mahesh -- itsmahesh ----------------------------------------------------------------------- itsmaheshp's Profile: http://www.excelforum.com/member.php...fo&userid=1585 View this thread: http://www.excelforum.com/showthread.php?threadid=27354 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable excell sheet cell from VB Script
Hi
something like with activesheet ..unprotect ..range("A1").locked=true ..protect end with "itsmaheshp" wrote: Hai guys, i want to disable the cell(making user not to enter the data in a particular cell) from VB Script(here i have to use VB Script becoz i have to disable this cell based on som other conditions.). plz help me... Thanks & regards, Mahesh P -- itsmaheshp ------------------------------------------------------------------------ itsmaheshp's Profile: http://www.excelforum.com/member.php...o&userid=15859 View this thread: http://www.excelforum.com/showthread...hreadid=273541 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable excell sheet cell from VB Script
Here you are a solution:
If myCondition Then Range("A1").Select 'e.g. Selection.Locked = True ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True ' it locks all cells in the worksheet, so set .Locked = False for the non-disabled cells! 'or with password ActiveSheet.Protect Password:="myPassword", DrawingObjects:=True, Contents:=True, Scenarios:=True End If Regards Stefi €žitsmaheshp€ť ezt Ă*rta: Hai guys, i want to disable the cell(making user not to enter the data in a particular cell) from VB Script(here i have to use VB Script becoz i have to disable this cell based on som other conditions.). plz help me... Thanks & regards, Mahesh P -- itsmaheshp ------------------------------------------------------------------------ itsmaheshp's Profile: http://www.excelforum.com/member.php...o&userid=15859 View this thread: http://www.excelforum.com/showthread...hreadid=273541 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disable Compatibility Mode in Vista for Excell | Excel Discussion (Misc queries) | |||
How can I disable all Hyperlinks in Excell 2000 | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc. | Excel Worksheet Functions | |||
can i register a digit in excell sheet cell | Excel Discussion (Misc queries) |