A couple of possible solutions. You can hide the worksheet and then password
protect the workbook which is reasonably effective at keeping people out out
your worksheet. Note that your workbook must be protected for this to work
and the workbook passwords are relatively easy to break with code that is
readily available.
Another solution is to change the visible property of the worksheet with a
macro. One option is to make the sheet very hidden. Doing this the worksheet
does not show up anywhere via the standard XL menus. Additionally you can
password protect the VB project to keep users out of the VBE which means that
they can not easily unhide the sheet.
All of that being said there is no 100% way to protect users from getting at
the sheet.
A couple of possible solutions. You can hide the worksheet and then password
protect the workbook which is reasonably effective at keeping people out out
your worksheet. Note that your workbook must be protected for this to work
and the workbook passwords are relatively easy to break with code that is
readily available.
Another solution is to change the visible property of the worksheet with a
macro. One option is to make the sheet very hidden. Doing this the worksheet
does not show up anywhere via the standard XL menus. Additionally you can
password protect the VB project to keep users out of the VBE which means that
they can not easily unhide the sheet.
All of that being said there is no 100% way to protect users from getting at
the sheet.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
