Macro to Protect cells

  • Thread starter Thread starter support
  • Start date Start date
S

support

Total Excel virgin here (and proud of it - LOL).

I'm putting together a sheet that will have a lot of cells that a
client will enter the values in, and then send to HIS client to fill
in the rest.

What I need to do, is pull up this sheet, allow my client to fill in
the fields he needs to, then run a macro to protect (password or
another variant) those cells.

As I will know each and every time which cells need to be protected,
what would the process be to create this?

If someone would at least point me in the right direction, I'd greatly
appreciate it.
 
Proud,

Cells are protected with Format - Cells - Protection. They're locked by
default; unlock those are to be allowed to be changed. To make this take
effect, protect the sheet (Tools - Protection - Protect sheet). The only
part that might need to be done in a macro is the protect sheet part. YOu
can use the macro recorder to get started with that.
 
Back
Top