Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking spreadsheet
I have written the following code but I continually get an error message
Sub Test() Dim ws As Workshee Set ws = ActiveShee 'Locking the Current Loan information section if Purchas If Range("C9").Value = "Purchase" The 'Skip the Current Loan Information Sectio ActiveSheet.Unprotec ActiveSheet.Range("C15:C20,K15:K19").Locked = Tru ActiveSheet.Protec End If End Su When I try and run it, I get the error message; "Unable to set the locked property of the Range class". I really am VERY new to this and have been trying to teach myself, but it is coming slowly. I am sure that I am making a simple mistake that someone will be able to fix. Also, I want it set up so that it knows to run the second that "Purchase" is selected in the combobox associated with C9 (ComboBox6) Thanks in advance Rya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking a Spreadsheet but allow inserting | Excel Worksheet Functions | |||
Locking a spreadsheet, yet allowing sort | New Users to Excel | |||
Locking cells in a spreadsheet | Excel Discussion (Misc queries) | |||
I have an excel spreadsheet that keeps locking up on me, I need he | Excel Discussion (Misc queries) | |||
need help with locking spreadsheet | Excel Discussion (Misc queries) |