Pausing macro for user Excel input
 

If data entry is only allowed in the first 5 columns, then select those five
columns and do Format=Cells=Protection Tab. Uncheck the Locked checkbox.
Then protect the sheet and only allow selection of unlocked cells. (if you
have xl2000 or xl97 you will have to set this the option to select only
unlocked cells in the properties window for the sheet).

--
Regards,
Tom Ogilvy



"TomD" wrote in message
...
I would like to create a macro that would improve efficiency in data input
to
an Excel spreadsheet. My operator needs to enter five columns of data per
row, then go to the next row's column A and start over. I've created a
simple
do loop to control cursor movement, but don't know how to pause the macro
while the operator keys in data. Is there any way to do this in VBA?

Here's what I have so far:

Sub detailline()
Dim c As Integer

Do Until c = 5
ActiveCell.Offset(0, 1).Select
c = c + 1
' I need to pause the macro at each column to allow for user input

Loop

ActiveCell.Offset(1, -5).Select
c = 0

End Sub

Thanks for your help,


--
TomD