Proteger Hoja

  • Thread starter Thread starter zuyin
  • Start date Start date
Z

zuyin

Hola chicos...
tengo una preguntica... Saben ustedes como puedo proteger varias hojas de
calculo de un mismo libro al mismo tiempo, sin necesidad de marcar una por
una?

Saludos y gracias
Zuyin
 
zuyin wrote...
Hola chicos...
tengo una preguntica... Saben ustedes como puedo proteger varias hojas de
calculo de un mismo libro al mismo tiempo, sin necesidad de marcar una por
una?
Click to expand...

Zuyin

I think you are asking how to protect individual sheets within a workout
simultaneously, without the need to set each sheet individually?

I am not sure how to do this, but perhaps with this "translation" someone
will jump in and answer. VBA maybe?

Waiting for more input,
Kevin
 
You can't do it through the userinterface.

But you could use a macro that protects all the sheets in a workbook:

Something like this:

Option Explicit
Sub testme()
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
wks.Protect Password:="Hi"
Next wks
End Sub

(Thanks, Kevin. that looked, er, Greek to me!)
 
Dave,

I know just enough Spanish to be dangerous. :-)

Zuyin,

1) Alt F11

2) inserte el módulo (insert module)

3) pegue el código (paste the code)

Option Explicit
Sub testme()
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
wks.Protect Password:="Hi"
Next wks
End Sub

4) De XL regulares (?) (from regular XL)

5) Alt F8

6) seleccione el programa testme (select the macro testme)

Bueno suerte (good luck)

Hasta luego, (literally, until later)
Kevin
 
Dave,

Thank you for assisting. A question just occured to me--does a Spanish
version (or any "foreign" language version) understand English VBA?

Best regards,
Kevin
 
I just barely speak English (American at that!).

But from what I've read, VBA code is English. (Your strings can be anything you
want, but the language is English, no matter what language excel is.)

I asked that same question about COBOL a 100 years ago.
 
Dave Peterson wrote
I just barely speak English (American at that!).

But from what I've read, VBA code is English. (Your strings can be anything you
want, but the language is English, no matter what language excel is.)

I asked that same question about COBOL a 100 years ago.
Click to expand...

Thank you Dave for your help. VBA is tough enough to learn, let alone a
second language on top of it. Glad that my first language is English.

I hope Zuyin checks back in and finds the information helpful.

Again, thank you.

Best regards,
Kevin
 
If it turns out that that original post was a recipe for salsa, then what do we
do???
 
Back
Top