Disable AutoFill

  • Thread starter Thread starter sowetoddid
  • Start date Start date
S

sowetoddid

The spreadsheet is being misformated due to autofill and border copying
Is it possible to do away with this function and force users t
manually type each number?


Thanks
 
<Tools> <Options> <Edit> tab,

At the bottom,

*Uncheck* Enable AutoComplete.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



The spreadsheet is being misformated due to autofill and border copying.
Is it possible to do away with this function and force users to
manually type each number?


Thanks.
 
I did that, and it did not seem to have an effect. Maybe there i
another way to go about doing this...

I have a block of about 500 cells that require text input (mainl
numbers, but also some plain text). I would like the user to only b
able to input the assigned values one at a time without alterin
-anything- else.

Right now the entire spread sheet is password protected with th
exception of these 500 cells. However, I have found that the autofil
and "drag and drop" have allowed users to modify the formating on th
sheet.

How can this be prevented?


Thank you
 
This worksheet event might stop most (but not all).

Right click on the worksheet tab that should have this behavior. Select View
code and paste this in.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then
With Application
.EnableEvents = False
.Undo
.EnableEvents = True
End With
MsgBox "One cell at a time!"
End If
End Sub

But if the user doesn't enable macros when the workbook opens, or disables
events later, then this won't be effective.
 
Back
Top