Copy & Paste for Password Protected Sheet Is Not Working

[LaurindaS]

I am working with a password protected sheet that has hidden columns. I used to be able to select all (Ctrl + A) and then copy a whole sheet, then go to a blank sheet & paste and then be able to see all the columns, including the hidden ones. Recently I found that I'm not able to do that anymore.

Does anyone know a way around this?

Thanks,
Laurinda

 

[Yongle]

Try PasteSpecial Values