Cells object question
Unless you know for certain that the sheet you are concerned with is the
activesheet then yes, you should always qualify the range object with the
relevant sheet, eg
ThisWorkbook.Worksheets("Sheet1").Cells.etc
In passing, I can't imagine why one would ever do .Cells.locked = False
Regards,
Peter T
"Robert Crandal" wrote in message
...
I am using the Cells object to set the "locked" property of
my spreadsheet. The line looks like this:
Cells.locked = True ' or can be False
I feel real uncomfortable using that code by itself. Shouldn't
I pre-qualify the Cells object with another object such as
"ThisWorkbook" or something?? I just want to ensure that
this code runs on the workbook it was intended for and not
another active workbook.
Thank you!
|