TABLA DINAMICA

%3CLINGO-SUB%20id%3D%22lingo-sub-1493863%22%20slang%3D%22es-ES%22%3EDYNAMIC%20TABLE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493863%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%20everyone%20I%20would%20like%20to%20know%20how%20to%20make%20the%20last%20row%20of%20my%20dynamic%20table%20double%20being%20doubled%20being%20protected%2C%20I%20know%20it%20is%20with%20macro%20but%20I%20am%20not%20very%20expert%20in%20macro%2C%20I%20would%20appreciate%20if%20anyone%20can%20help%20me%20in%20this%20case%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1493863%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hola a todos quisiera saber como hacer que la ultima fila de mi tabla dinamica se duplique estando protejida, se que es con macro pero no soy muy experto en macro, agradeceria  si alguien puede ayudarme en este caso

 

1 Reply
Hello there,

It's unclear what you want specifically. It sounds like you're aware you can't increase a Table rows when the sheet is protected. If you want to work around this, you must either do so manually or use VBA. If you want to use VBA, the process is basically like this:

1. Unprotect the sheet
2. Do your work
3. Re-protect the sheet

If you're more specific about what you need we can possibly help more.