How To Determine If A Workbook or Worksheet Is Password Protected With Excel VBA

How To Determine If A Workbook or Worksheet Is Password Protected With Excel VBA

If you want to prevent errors from occurring when you macro code is running, it may be necessary to check for password protection.  Below are a couple VBA code snippets that will show you how to use an IF statement to determine if the ActiveSheet or ActiveWorkbook are currently password protected.

Read More

Make All Charts Plot Non-Visible Cells in Your Excel Workbook

Make All Charts Plot Non-Visible Cells in Your Excel Workbook

When you create a chart in Microsoft Excel, the chart's default setting is to not graph any spreadsheet cells that are hidden (or not visible).  I often like to hide or collapse (via column or row groups) data in my spreadsheets and this is a setting that is a pain to go in and manually change when you have to apply it to a bunch of charts.  Use the below macro to change every single graph in your workbook to Plot Non-Visible Cells.

Read More