Yes, please elaborate. We're not scared of VBA.



"Alex" wrote in message
...
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?