Can Excel be used as an active database that is un-editable

[glenray]

I need to make a database (Work Log) that after an entry is made, a macro can enter the record, protect it and ready the database for the next record.

Can that be done with VBA?

 

[Jeffrey Mahoney]

You can hide a sheet so that a user cannot see it all all. You can have a macro add an entry to that sheet. And then you can lock the VBA project so that users cannot use your code to unhide it. There are ways to thwart this, but most cannot. You could also protect the sheet and have the macro unlock it to add an entry.

Sub HideSheet()
Dim Sht As Worksheet
Set Sht = Sheets("Sheets3")
Sht.Visible = xlSheetVeryHidden
End Sub

 

[Logit]

How will you account for USER ERROR regarding their entries ?

 

[Jeffrey Mahoney]

I make data entry screens. When an entry is entered, it is visible in a table below. The user can choose that record again, edit, and save again.

 

[Logit]

Each tab has just over 1.4 million rows ... each row can hold a single record of data. How many records do you perceive a single tab
will hold ?