Active Workbook
Hello all,
I'm a bit confused on when we need to use the 'ActiveWorkbook' keyword when
writing VBA code. For example, to unprotect a sheet, i normally use the
statement:
ActiveSheet.Unprotect
I'm wondering if that's good enough or I am supposed to go one level up by
referring to the workbook the activesheet belongs to, eg:
ActiveWorkbook.ActiveSheet.Unprotect
I'm using Excel 2003.
Many thanks in advance
Tendresse
|