protect a sheet such that it cannot be deleted

[sam]

Can I protect a sheet such that users cannot delete or edit or view it?

Thanks in Advance

 

[Dave Peterson]

Not really.

Any suggestion that you get would rely on worksheet and workbook protection and
those are pretty easy to break.

So if you don't want others to see the data, don't share that data with them in
excel.

 

[sam]

Thanks for your help, In my situation.. I take user inputs from sheet1
through a userform, and those user inputs are stored in sheet2. So I need
them to access Sheet1 only and not sheet2. Hence I want sheet2 to be
protected such that it cannot be edited, viewed or deleted by these users but
me.

 

[Dave Peterson]

You can make the sheet visible via the properties window (in the VBE) for that
sheet. You'd want to protect the workbook project, too.

But this workbook protection is easily broken and code to unhide the sheet could
exist in a different workbook's project.