How to protect a column?

  • Thread starter Thread starter xpucto
  • Start date Start date
X

xpucto

Hi!

I would like to protect some hidden columns. When I choose
"protection" in the menu, I only find the possibility to define area to
be modifed but I would like to do the opposite: define which areas can´t
be modified.

How can I do this?

Thanks.
 
Is there some kinf of options to protect all hidden columns? Or to
protect functions?
 
Cells are locked or unlocked.
Worksheets are protected or not protected.

If you lock all the cells you want to stop changes, then protect the sheet,
won't you have what you need?

In xl2002+, you can allow some users (who know a password) to change certain
ranges. But I don't see how that would affect any locked cell on a protected
sheet (if you didn't use this extra granularity feature).
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

Protecting Pivot Tables. 2
Excel Protection 2
hide columns on a protected sheet??? 1
Protect a sheet but allow columns to unhide 1
Protecting a header/footer 3
Protect Hidden Columns 1
Macro to insert a row and copy down formulas from row above 2
Hiding columns in a protected sheet 4

Back
Top