Autofill

[bryan.delara]

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.

 

[Pete_UK]

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

 

[Gord Dibben]

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

 

[bryan.delara]

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





- 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.