Password Protect to Hide and Unhide the Worksheet

Dear Experts,

I have a worksheet Sheet25 named as "RANGES" and i am looking for the macros to prompt password when if someone Hide or Unhide this worksheet. Request to you please do help me out.

Many thanks and kind regards,

Neilesh

Please Login or Register  to view this content.

Originally Posted by Logit

Please Login or Register  to view this content.

Dear Expert,

Thank you so much for your precious efforts, Please do let me know for the above provided details where i need to make the changes in the code and do i required to use the macro in individual worksheet or in a module.

Request to you, if you can please do provide the code with the provided worksheet name in my very first post, would be highly appreciated.

Many thanks and kind regards,

Neilesh

The macro code goes in a Routine Module.

The sample file is already attached.

See attached :

Originally Posted by Logit

See attached :

Dear Expert,

Thanks a ton for your precious support and valuable phase. Once again thanks a lot Sir.

Regards,

Neielsh

You are welcome.