Quote Originally Posted by Simon Lloyd
Thats probably because the project you are manipulating must be unlocked!

I made the project.
then in vbaproject properties given it a password.
now as it is password protected I can not run my macro as in the begining it wants sheet name internally which XLD has given earlier in this thread.

the problem is if i do not protect the project with password it run smoothly but this will let others see my whole coding which I dont want to.

So I need some coding or refence of VBA to internally check for password (iam ready to provide if needed in coding) & execute my macro but it should not show coding to others