I was trying to delete the contents of a cell with the delete key and I got the error:
The cell or chart you are trying to change is protected and therefore read-only.
I know the sheet was protected, but I was certain the cell was unlocked. I was certain because I created a style for [...] Read More...
From Wikipedia:
Runways are given a number between 01 and 36. This indicates the runway’s heading: A runway with the number 36 points to the north (360°), runway 09 points east (90°), runway 18 is south (180°), and runway 27 points west (270°). Thus, the runway number is one tenth of the runway...
Here’s a utility to format unlocked cells using conditional formatting so that I can easily see that I’ve set the Locked property appropriately.
Private msFormula As String Sub ToggleLockedCellFormat()
Dim sh As Worksheet
Dim rng As Range
...
In New Zealand, we format our dates dd/mm/yy. However, the United States format as mm/dd/yy.
When I see a date by itself, like 12/01/09, I ask “is this the 12th of January or the 1st of December”?
When I started working with Oracle RDBMS, a habit I picked up was to format dates dd-mon-yyyy...
Nothing wrong with this sheet, right? Until you get to the end… The teeny-tiny vertical scrollbar handle is usually a give away. Hundreds of rows tacked onto the end of the list to give the illusion that the whole column has been formatted.
The trouble with formatting columns as per the above image...
It is possible to get a cell to display one thing, but store another.
Create a Custom Format by right-clicking the cell, select Format Cells…, then from the Number tab select Custom.
In the Type box use whatever text you want displayed, but be sure to enclose it in “double-quotes”....
Hi all,
I’ve just published a new article on my website. Here is the introduction:
“This article explains how you can use styles to ease maintenance of your spreadsheet models.
Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills...