| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active Workbook
On Feb 4, 9:51*am, Tendresse
wrote: 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 Hi Tendresse As far as i know Excel assumes Activeworkbook and Activesheet if you omit them. With your example for unprotecting it therefore doesn't matter if you put the activeworkbook or not, on the other hand the activesheet is needed because you have to tell excel what you want to unprotect. If you take an expression like range you can write like that: activeworkbook.activesheet.range activesheet.range or just range it's all the same. hope that helps Carlo |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active Workbook
Thanks for your help, Carlo. Much Appreciated.
"carlo" wrote: On Feb 4, 9:51 am, Tendresse wrote: 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 Hi Tendresse As far as i know Excel assumes Activeworkbook and Activesheet if you omit them. With your example for unprotecting it therefore doesn't matter if you put the activeworkbook or not, on the other hand the activesheet is needed because you have to tell excel what you want to unprotect. If you take an expression like range you can write like that: activeworkbook.activesheet.range activesheet.range or just range it's all the same. hope that helps Carlo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Closing Hidden Workbook when Active Workbook is Closed | Excel Programming | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
| How do I make an open workbook the active workbook | Excel Programming | |||
| Copy Modules from One workbook to Active Workbook | Excel Programming | |||
| Preventing opening workbook inside active workbook. | Excel Programming | |||
Hybrid Mode
