Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protection problems with 07
I have a ton of excel 03 forms that have code attached to a check box that
bolds the font in the cell to the right of the checkbox. here's the code Sub Bold() Dim CaseNum As String CaseNum = Application.Caller CaseNum = Right(CaseNum, 2) Range("B" & CaseNum).Font.Bold = Range("A" & CaseNum).Value End Sub This works fine until I open the sheet in 07. The cell is protected in 03 with the "format cells" box checked. It works fine in 03. The sheet in 07 tells me that the cell is protected and stops the code. I have unprotected the sheet and then reprotected it verifying that that box is checked but get the same results. Can anyone help m figure out this protection dilema? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro protection problems | Excel Discussion (Misc queries) | |||
Problems with cell protection-Excel 2002 SP3 | Excel Discussion (Misc queries) | |||
Cell Protection Problems | Excel Discussion (Misc queries) | |||
Command Button protection problems???? | Excel Worksheet Functions | |||
Protection problems | Excel Programming |