error with MsgBox

**ramserp** · 12-10-2009, 03:13 AM

Hi Friends,

I worte a procedure to protect the worksheet. When we clik on command button it asks the password but if I click on cancel button procedure is exiting.

Please help me with this code.

Please Login or Register  to view this content.

Thans and Regards
Ramesh

**royUK** · 12-10-2009, 04:40 AM

I think this is what you want

Please Login or Register  to view this content.

**ramserp** · 12-10-2009, 04:54 AM

Hi Roy,

When I click on Cancel button it is not closing the inputbox window.

I have attached my excel please verify it.

Thanks & Regards
Ramesh

**royUK** · 12-10-2009, 05:00 AM

The password for the attched sheet is not sadc

**royUK** · 12-10-2009, 05:06 AM

I've changed the password to sadc & the code works ine

Please Login or Register  to view this content.

**ramserp** · 12-10-2009, 05:33 AM

Hi Roy,

When I click on Cancel button the inputbox window is not closing. Please kindly correct the following code.

Please Login or Register  to view this content.

Thanks & Regards
Ramesh

**royUK** · 12-10-2009, 05:51 AM

Your code was written that way, all I've done is make it work as the code seemed to want it to. Have you edited someone else's code?

The idea with the Forum is to provide help, you should study the code & try to make such simple changes yourself

Please Login or Register  to view this content.

**ramserp** · 12-10-2009, 06:23 AM

Hi Roy,

Thank you very much for spending your valuable time to reply my posts.

I wrote this procedure myself by refering a similar procedure. I am newbie of VBA so I am facing some problems with logic.

Thanks & Regards
Ramesh

**royUK** · 12-10-2009, 06:39 AM

No problem. try to understand the code 7 post back with specific questions on anyhing that you do not understandIf you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You might also like to rate any answer(s)