See in-line

On Fri, 12 Feb 2010 16:02:26 -0700, "Robert Crandal"
wrote:

What if my VBA project is password protected so they cannot
access any of the code modules??? Will that help??

Not much. I'll just run code from another workbook to access your hidden
sheets if I know the names.


What are a few ways I can prevent anyone from modifying
data on a hidden sheet??? I need to cover my bases as much
as possible.

Since you're dealing with Excel's relatively weak internal security you
would be hard-pressed to cover all bases.

How sophisticated are your snoopy users and how much time and effort are
they willing to expend?

If the hidden worksheets were protected.....all cells locked and unprotect
password set, users would have to know password to alter cells even if they
could unhide the sheets.

But easy enough to crack sheet passwords.

If the workbook structure was protected with a password, hidden sheets could
not be unhidden through code.

But easy enough to crack workbook protection passwords.

I am assuming the hidden sheets' cells are referenced by the visible sheets
so simply removing those sheets is not an option.


Gord

thank u


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .

Yes, through VBA a user could alter values on a hidden sheet if they knew
the tab name or codename of that sheet.

Or they could run VBA to unhide the sheet and change everything on it.

Or even delete it.