ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   protection problems with 07 (https://www.excelbanter.com/excel-programming/382428-protection-problems-07-a.html)

JCanyoneer

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?


All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com