On 7 Nov, 01:38, Gord Dibben <gorddibbATshawDOTca wrote:
What you are talking about is "AutoComplete" not autofill.

This is an Application-wide setting, not a workbook or worksheet setting.

You would have to use event code to turn it off in one worksbook only and
turn it back on when you switch to another workbook or close the first
workbook.

Will you have both workbooks open at the same time or just one at a time?

Gord Dibben *MS Excel MVP



On Thu, 6 Nov 2008 16:32:43 -0800 (PST), wrote:
Can I turn off autofill on one workbook but still have it on, on
another workbook if they are both open?
The problem I have is this. I have one workbook that requires A's,
D's, hd's ect in a cell. In other cells I have names, but I don't want
it to autofill. On another workbook I want autofill on to save having
to type everything.
Any idea's?
Bryan.- Hide quoted text -

- Show quoted text -

The reasons being that we use Excel for a multitude of different jobs.
I need to have several workbooks open at the same time. Manning, stock
counts, 5S reports, process confirmations, loading slips and Absence
management, to name but a few. Agreed I don't need all of them at the
same time, but I do most.
I need to have Autocomplete off for one workbook, but on for the
others. But anyway, my question was answered, thank you all.