When creating a worksheet that needs to be filled in by a client/end user to collect data, you might want to require certain fields/cells to be populated. In other words, there may be certain cells like "Client Name" that need to be filled in, in order for the worksheet to be further processed (either by code or manually). We'll want to prevent end users from submitting an incomplete worksheet to us by making certain cells required.

Continue Reading: A simple debug mode for your Excel workbooks »