View data from form control button

[julie d]

Is it possible to configure the workbook so the user can view the data in the worksheet from the form and I can hide the actual worksheet so that the data in the workshhet cannot be changed? Or maybe there is a better way all together??

I am attaching a copy of the worksheet.

Second, Is there a better way to input a code that would allow a search for duplicates in certain fields to be flagged (other than the color coding?)

[D_Rennie]

Could you protect the worksheet by using ws.unprotect at the start of cmdadd and ws.protect at the end.

this will let you view the worksheet and disallow and changes to be made while viewing the sheet.

hope this helps in some way

[royUK]

You can hide the aplication on initialising the userform. You have to be extremely careful that your code also restores the aplication o else you will find that he user has a hidden instance of excel running. I've tidied up your code & added the code to hide/unhide Excel

Please Login or Register  to view this content.

[julie d]

Roy,
I cleaned up the code as you indicated and added the code to hide the excel, that works great as a bonus feature. I'm sure I am confusing about what I am trying to do(I'm easily confused) The person entering the data has to see the data (actually they only need to see if the data they entered matches existing data) BUT I am trying to make it so they cannot change previously entered data. Hopefully that makes sense.
Julie d

[julie d]

DRennie,
That sounds worth a try- I will try to figure out how to do that.
Julie d

[royUK]

The code will work on any sheet because you set it to

Please Login or Register  to view this content.

The data sheet does not need to be visible or active

[julie d]

I am still having the same original problem in that the user can manipulate data on the worksheet. I would like that to be view only by anyone but the administrator.