Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with locking Cells
Hi I am trying to lock and unlock cells in an Excel 97 App via VB code. I have the following function Private Sub Workbook_Open() ActiveSheet.Unprotect password:=Worksheets("sheet2").Range("PWD") Worksheets("sheet1").Range("A1:BH22").Locked = True Range("CompletedBy").Locked = False ActiveSheet.Protect password:=Worksheets("Sheet2").Range("PWD"), userinterfaceonly:=True End Sub Setting the Locked property works fine using a reference like "A1:B H22" but fails when using a named range. Does anyone have any idea why I cannot use a named range in this code. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with locking Cells
It seems to me it should work fine... are you sure you spelled the name of
the range correctly? are you sure that the name exists and has a valid reference? RADO "rthomsen" wrote in message ... Hi I am trying to lock and unlock cells in an Excel 97 App via VB code. I have the following function Private Sub Workbook_Open() ActiveSheet.Unprotect password:=Worksheets("sheet2").Range("PWD") Worksheets("sheet1").Range("A1:BH22").Locked = True Range("CompletedBy").Locked = False ActiveSheet.Protect password:=Worksheets("Sheet2").Range("PWD"), userinterfaceonly:=True End Sub Setting the Locked property works fine using a reference like "A1:B H22" but fails when using a named range. Does anyone have any idea why I cannot use a named range in this code. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with locking Cells
Range(ActiveWorkbook.Names("CompletedBy")).Locked = False
"rthomsen" wrote in message ... Hi I am trying to lock and unlock cells in an Excel 97 App via VB code. I have the following function Private Sub Workbook_Open() ActiveSheet.Unprotect password:=Worksheets("sheet2").Range("PWD") Worksheets("sheet1").Range("A1:BH22").Locked = True Range("CompletedBy").Locked = False ActiveSheet.Protect password:=Worksheets("Sheet2").Range("PWD"), userinterfaceonly:=True End Sub Setting the Locked property works fine using a reference like "A1:B H22" but fails when using a named range. Does anyone have any idea why I cannot use a named range in this code. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking Cells | New Users to Excel | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking Cells | Excel Discussion (Misc queries) | |||
Locking Cells | Excel Worksheet Functions | |||
Locking certain cells | Excel Worksheet Functions |