| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
about protection
Hello
I have made one excel sheet using Macro code for hide some rows with check box. But i could not protect the sheet. If i protect it , check box doesnot work. Can you help me to protect sheet . pmss |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
about protection
Do you mean that the checkbox doesn't work, or the code behind it?
If the former, either check the 'Edit objects' option in the protection dialog, or use a checkbox from the forms toolbar. If the latter, unprotect the sheet before your code, then re-protect it afterwards. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pmss" wrote in message ... Hello I have made one excel sheet using Macro code for hide some rows with check box. But i could not protect the sheet. If i protect it , check box doesnot work. Can you help me to protect sheet . pmss |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
about protection
"Bob Phillips" wrote: Do you mean that the checkbox doesn't work, or the code behind it? If the former, either check the 'Edit objects' option in the protection dialog, or use a checkbox from the forms toolbar. If the latter, unprotect the sheet before your code, then re-protect it afterwards. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pmss" wrote in message ... Hello I have made one excel sheet using Macro code for hide some rows with check box. But i could not protect the sheet. If i protect it , check box doesnot work. Can you help me to protect sheet . pmss Thanks. Still does not work. I have used following codes for check box. Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Rows("18:39").Hidden = False Else Rows("18:39").Hidden = True End If End Sub I want to protect this sheet. When i protect the sheet the check box doesnot work, it gives some error. Pmss |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
about protection
What doesn't work, I gave many suggestions? You need to be more explicit.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pmss" wrote in message ... "Bob Phillips" wrote: Do you mean that the checkbox doesn't work, or the code behind it? If the former, either check the 'Edit objects' option in the protection dialog, or use a checkbox from the forms toolbar. If the latter, unprotect the sheet before your code, then re-protect it afterwards. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pmss" wrote in message ... Hello I have made one excel sheet using Macro code for hide some rows with check box. But i could not protect the sheet. If i protect it , check box doesnot work. Can you help me to protect sheet . pmss Thanks. Still does not work. I have used following codes for check box. Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Rows("18:39").Hidden = False Else Rows("18:39").Hidden = True End If End Sub I want to protect this sheet. When i protect the sheet the check box doesnot work, it gives some error. Pmss |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
about protection
hi
check box doesnot work, when i protect the sheet. It gives Run time error 1004. Unable to set the hidden property of the Range class. pmss "Bob Phillips" wrote: What doesn't work, I gave many suggestions? You need to be more explicit. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pmss" wrote in message ... "Bob Phillips" wrote: Do you mean that the checkbox doesn't work, or the code behind it? If the former, either check the 'Edit objects' option in the protection dialog, or use a checkbox from the forms toolbar. If the latter, unprotect the sheet before your code, then re-protect it afterwards. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pmss" wrote in message ... Hello I have made one excel sheet using Macro code for hide some rows with check box. But i could not protect the sheet. If i protect it , check box doesnot work. Can you help me to protect sheet . pmss Thanks. Still does not work. I have used following codes for check box. Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Rows("18:39").Hidden = False Else Rows("18:39").Hidden = True End If End Sub I want to protect this sheet. When i protect the sheet the check box doesnot work, it gives some error. Pmss |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
about protection
So did you read my first post?
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pmss" wrote in message ... hi check box doesnot work, when i protect the sheet. It gives Run time error 1004. Unable to set the hidden property of the Range class. pmss "Bob Phillips" wrote: What doesn't work, I gave many suggestions? You need to be more explicit. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pmss" wrote in message ... "Bob Phillips" wrote: Do you mean that the checkbox doesn't work, or the code behind it? If the former, either check the 'Edit objects' option in the protection dialog, or use a checkbox from the forms toolbar. If the latter, unprotect the sheet before your code, then re-protect it afterwards. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pmss" wrote in message ... Hello I have made one excel sheet using Macro code for hide some rows with check box. But i could not protect the sheet. If i protect it , check box doesnot work. Can you help me to protect sheet . pmss Thanks. Still does not work. I have used following codes for check box. Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Rows("18:39").Hidden = False Else Rows("18:39").Hidden = True End If End Sub I want to protect this sheet. When i protect the sheet the check box doesnot work, it gives some error. Pmss |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
about protection
Another thing to check...
Do you have a linkedcell to that checkbox? And is that linkedcell locked and located on a protected worksheet? Unlock that cell (format|cells|protection tab in xl2003) pmss wrote: Hello I have made one excel sheet using Macro code for hide some rows with check box. But i could not protect the sheet. If i protect it , check box doesnot work. Can you help me to protect sheet . pmss -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
| protection | Excel Discussion (Misc queries) | |||
| Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
| Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
| Protection | Excel Worksheet Functions | |||
Hybrid Mode
