Form Function Help

  • Thread starter Thread starter LiquidCougar
  • Start date Start date
L

LiquidCougar

I am a technician for a Nextel Service Center, and I have developed a
work order system using Excel 2002. It is replacing paper work orders
to increase efficiency.

It's a simple form, and the data input consists mostly of names, ID
numbers, and descriptions.

There's one field that contains a 5-digit work order number. What I
want to do is, create a button that saves the worksheet with that work
order number as the file name, clear all unlocked cells, and repopulate
the work order number field one number higher.

This would complete my system PERFECTLY!!

Also, when I lock and protect my sheet, I check the inability to select
locked cells. It works fine on my machine, but the P.O.S. system out
front will still select them. Any way around this?

THanks, Jes.
 
I'm guessing the POS systems out front are running an earlier version of excel.
(xl2002 added the checks to the worksheet protection scheme.)

You could protect the worksheet in code:

Option Explicit
Private Sub Workbook_Open()
With Worksheets("sheet1")
.Protect Password:="hi"
.EnableSelection = xlUnlockedCells
End With
End Sub

And that'll work for both xl2002 and earlier.

(POS=point of sales or piece of ...? <vbg>)
 
Back
Top