How to Potect a Worksheet and Workbook in Excel
Tuesday, September 1st, 2009
http://www.TeachExcel.com
How to protect a worksheet and workbook in excel. This will prevent unauthorized people from editing, deleting, or changing data in excel.
Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website:
http://www.TeachExcel.com
Duration : 0:7:44
Another interesting method to access cells when writing VBA macro code in the Visual Basic Editor. Accessing cells using the ‘cells’ property has major advantages when using ‘do while’ and ‘for… next’ loops.