Defining Global Variable from form to sheet

[ChemistB]

Here's what supposed to happen:
From a button in worksheet with code in the worksheet, I call a user form "Password"
I input a password which it saves as "PWord" and it checks to see if it's good (in user form code) and unlocks the sheet if it is.
Then hides the form
The code in worksheet then does some stuff and locks the sheet using PWord
However, seems PWord has become "" and I'm left with an unprotected worksheet.

I've tried putting
"Dim PWord as string" outside the Form code, outside the worksheet code but doesn't seem to matter.
Any thoughts on what I'm doing wrong?

[judgeh59]

Try;

Please Login or Register  to view this content.

I alway put all my Globals at the top, right under Option Explicit....HTH

[JosephP]

you need to have

Please Login or Register  to view this content.

in a normal module and remove all other declarations of the variable. or make it a property of the worksheet and have the form set that property

[ChemistB]

Thank you I will try that.

[judgeh59]

Bump....just curious if that fixed your issue.....inquiring minds want to know...thanks

[ChemistB]

Hi Judge,
Sorry, was working on other things and am just getting back to this. It did not work. I'm attaching a stripped down version. Maybe I'm putting the "Public" statement in the wrong place. The password is "thisword"
Clicking on the green button "Unhide Details" should (and does) pull up the password form to enter a password but this password is not being carried back to the main routine.

[Norie]

Insert a new standard module (Insert>Module).

Declare PWord in the new module.

Also, remove all other declarations of PWord.

[jaslake]

Hi ChemistB

You have Public PWord As String in the Sheet Module (Login) and in ThisWorkbook Module...get them out of these two places. The put it is a Standard Module.

[judgeh59]

yup....everybody seems to be in agreement....bad thing on my part, I assumed you had a standard module and I should have asked for an example....

[ChemistB]

Yep, this worked. Good to know. Thanks to all!

[jaslake]

Hi ChemistB

If you'd be so kind, please mark your Thread as "Solved"...