Team,
I have a workbook with a hidden sheet (Using the very hidden VBA function).
I have password protected the macros themselves and password protected the
button to run the macro.
Obviously if a user could get the VBA from design mode they could get the
password for the hidden sheet.
The hidden sheet is also protected. But the structure of the workbook is
not protected, or other macros do not work (As needed by the user).

Users can see that the data is being pulled from a sheet which they cannot
access. They enter data and the answer field shows "Hidden data A45" etc.
However, all one has to do to get information from the hidden sheet is to
insert a new worksheet (Or open a new workbook) and type the correct path to
the hidden sheet referencing cell A1 and then copy the whole lot into the new
sheet.
I need to stop that. I cannot use an msi as that requires putting on the C
drive, which is not possible in my organisation.
Any ideas?

Any takers?

"Paul" wrote:

Team,
I have a workbook with a hidden sheet (Using the very hidden VBA function).
I have password protected the macros themselves and password protected the
button to run the macro.
Obviously if a user could get the VBA from design mode they could get the
password for the hidden sheet.
The hidden sheet is also protected. But the structure of the workbook is
not protected, or other macros do not work (As needed by the user).

Users can see that the data is being pulled from a sheet which they cannot
access. They enter data and the answer field shows "Hidden data A45" etc.
However, all one has to do to get information from the hidden sheet is to
insert a new worksheet (Or open a new workbook) and type the correct path to
the hidden sheet referencing cell A1 and then copy the whole lot into the new
sheet.
I need to stop that. I cannot use an msi as that requires putting on the C
drive, which is not possible in my organisation.
Any ideas?