Locking objects has no effect unless the sheet is protected. To help protect the sheet, choose Format on the Home tab, and then choose Protect Sheet. A password is optional.
link_location,friendly_name!Creates a shortcut or jump that opens a document stored on your hard drive, a network server, ...
Local file system location of the workbook file cache. If the string is empty, the cache will be located in a subdirectory ...
Locking cells or hiding formulas has no effect until you protect the worksheet (Review tab, Changes group, Protect Sheet ...
Locking objects has no effect unless the sheet is protected. To help protect the sheet, choose Format on the Home tab, and ...
Locking objects has no effect unless the sheet is protected. To help protect the sheet, choose Format on the Home tab, and ...
logical1,logical2,.!Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE!are 1 to 255 conditions ...
logical1,logical2,.!Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments ...
logical_test,value_if_true,value_if_false!logical_test!Checks whether a condition is met, and returns one value if TRUE, ...
lookup_value,lookup_array,match_type!Returns the relative position of an item in an array that matches a specified value ...