What if Macros->Record New Macro... is grayed out?
Where is the button that's labeled "Un-gray-out the Macros->Record New Macro... Menu Item, Please"
And no, the .xls file, nor the worksheet, nor the selected cell(s) are locked.
Seriously, I would like to ensure a group of cells are locked, too, and do it in the Private Sub Workbook_Open() procedure.
Needless to say, things like:
application.Worksheets("BuffyRulz").Range(some cell ref, some other cell ref).Locked = True
Excel barfs on completely. With all the orthogonality built into the Range object, the Range object is curiously unorthogonal. Like they built it, but they won't let you use it.
This message was edited by AChimpNamedCornelius on 2002-09-09 13:45
This message was edited by AChimpNamedCornelius on 2002-09-09 13:46