Ted

As far as I am aware, that is global i.e. applies to all sheets. Just tried
it and it seems that way.

There is another way around your problem but it involves VBA. Are you
familiar with VBA?

The solution to your problem would be quite simple and would be sheet
specific.

Is this of any interest?

Alex
"Ted Dawson" wrote:

Is that setting global, across all the sheets in the workbook, or can it be
set for each sheet?