On some excel sheets that I've received, the active area is clearly defined with the rest of the worksheet in a dark blue. Although it is not password protected, one cannot click a cell outside the active area and I cannot find out how this is done. It doesn't show up on page set, preferences or properties. Also, in the area outside the active area, columns, rows do not appear. I'd like to use this feature but don't know how to replicate it with forms that I must distribute.
See the Calendar Array Excel file attched. Any suggestions?
Also, I cannot find any button or paper clip to allow me to upload a sample file.
Bookmarks