• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Toggle Protect

Juzar22

Member
I have an excel file where i am using VBA code for highlight active row and column , now i also want to use toggle (turn on/off) worksheet protection when pressing Ctrl + u keys together will unprotect the worksheet, and pressing Ctrl + u keys together again will protect the worksheet again.

BUT i am getting RUN TIME error , attached is the error screen shot and my excel file, requesting for correction in code to solve the problem. Thanks
 

Attachments

NARAYANK991

Excel Ninja
Hi ,

Can you bring up the Visual Basic editor screen , click on Tools and then References , and show a screenshot of what is displayed ?

Narayan
 

NARAYANK991

Excel Ninja
Hi ,

It is clear that your computer is missing the Calendar control.

Since this is not necessary , I am uploading this workbook , without this control added.

See whether everything works now.

Narayan
 

Attachments

Juzar22

Member
Hi ,

It is clear that your computer is missing the Calendar control.

Since this is not necessary , I am uploading this workbook , without this control added.

See whether everything works now.

Narayan
Dear Narayan
Working perfect now, Thank You so much :)
 
Top