Run-time error '1004' when sheet is locked

Hello!

I have a problem when I try to run macros on locked sheet. When the sheet is unlocked, macros work perfectly, but when I locked them, I get message: Run-time error '1004' (and rest is in croatian, so I don't know how would it be in english)..

I'm not native english speaker, so I think you will understand my problem best if you try to do it on example.

So, you have to open Woorkbook and select sheet 'Ocjene financijskih pokazatelja'. The sheet is unprotected so the macros related to that sheet (which are assigned to objects uperleft) are working just as I want. I recomend to try them to understand what they do. They just hide and unhide some columns and set value in one cell. The first is called odn_dan_kred_prim_dep.

After that, you shold protect that sheet and try macros again. They won't work..

I'm not an excel expert so the macros are quite simple, I think. I' m working on this as a part of my final work to get faculty degree, and it's very important to me to solve this..

So, I would be very grateful if someone could solve my problem!

P.S. I deleted unnecessary sheets and macros to reduce the file size.

Best regards,

Dejan

OK, but I don't know how to do that.. :|

Could you write me a sample code just to see the sintax, please? Since I'm not very familiar with macros..

And what about password? Will that method ask user to write password every time he run macro?

Yeah, it works!

Thank you very much!

Best regards,
Dejan

This worked well. thanks