VBA Tips: Worksheets and Workbooks

Worksheets and Workbooks

• Ban the selection of multiple cells
• Determining the number of the last row
• Display or hide a worksheet
• Force enabling of macros
• Hide tabs
• Prevent editing the name of a tab
• Preventing a file from being saved
• Protect access to VBA code with a password
• Retrieve conditional formatting color with an Excel function