Well, if you are only typing A, or D or h in one column it is hardly
worth having autofill on, so if you turn it off (because you don't
want it for the other column) then you are hardly missing out on
anything in that workbook. Why do you need both open at the same time?
Can you not enter data into one workbook (with it turned off) and then
enter data into the other workbook (with it turned on again)?

Hope this helps.

Pete

On Nov 7, 12:32*am, 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.