Read Only VBA Sheet

[MelissaJordan]

Hello,

Can anyone help I have created a excel spreadsheet where by different users can add information into a spreadsheet through a user form.

The information is then displayed a sheet within the workbook.

By only problem is that some users are going in and messing with the data, is there anyway I can make it read only with out it affecting inputting data.

i tried making the sheet read only put the userform comes up with an error.

Thanks

Mel

[Andrew-R]

The user form will need to uprotect the sheet when it wants to write data and re-protect it when it has done so.

[MelissaJordan]

Can you point me in the right direction, can find the coding for it.
Thanks

Mel

[Andrew-R]

Unprotect the sheet using...

sheet.Unprotect("secret")

You'll have to set the sheet object to match the sheet you're writing data to and set the password to whatever your real password is.

Protect it again using

sheet.Protect("secret")

[royUK]

Try the ProtectWithUserInterface method. For details & example see here