Protecting against Macro Hacks

  • Thread starter Thread starter James
  • Start date Start date
J

James

Dave,

Do you know of a way to protect an excel workbook from modifications by
macros?

Example:
A1: Input Cell - Unprotected
A2: Ouptut Cell - Hidden Values so user can not see the formula.

1) I want to allow the user to enter values in the input cell and view
values in the output cell
2) I want to disallow a macro from entering a value in the input cell
and copying the value from the output Cell

Pretty much, I don't want somebody to write macros to interogate my
hidden formulas in a brute force attack. If they want to do it by hand,
no problem, but it will take them awhile... a long while.

Is this possible? Or if the user can modify a cell, then a macro can
too?

-james

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
Hi James

A macro can do whatever the user can do (and faster, and a few more things).
You can't protect against "a macro user".

HTH. Best wishes Harald
 
James,

Protecting the sheet will disallow a macro from changing cells. You must
use a password. It's not real secure -- there are password crackers. And
marking a cell Hidden (Format - Cells - Protection) (and protecting the
sheet) will prevent a macro from looking at the formula in a cell.
 
Back
Top