Thanks for the info, Solus.
I've been away for the week, but I had another look at it. I Recorded a macro by highlighting the cells I want, which (With a bit of tidying up), gave this:
It looks like the merged cells were confusing things - This code gives the desired behaviour: Spell checks the three "Cells" using the normal spellcheck window, and does not prompt to check other cells.
However, this stops working when the worksheet is protracted: It ends with "Run-Time error 1004 CheckSpelling Method of Range Class failed"
When I check the merged cell properties, they aren't set to locked or hidden. Can anyone suggest what to look into to make that code snippet work with protection?
Bookmarks