Firstly, you can seta public variable anywhere. As public, it is accessible
to any macro.

Second, you do not Set a string variable, just assign it

Pwd = "owntext"

You can protect a project in the VBE, ToolsPropertiesProtection, but it
will only deter a casual onlooker, it is easily circumvented.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Damon" wrote in message
...
Hi all,

I have a public variable that is currently declared as string at the top
module 1

How and where should I set/define the variable value so that it is the
same
and available to any macro/procedure in the project/wookbook?

currently trying

set Pwd = "owntext" ' Pwd is the public variable

The value for Pwd is the password for locking/unlocking sheets so I do not
want to have to set it more than once if possible..

On a kind of related note is there a way to stop people viewing the
macros?

I can protect pages, I can prevent the original file being over written, I
can even prevent anybody other than me from saving the file at all but
this
is almost pointless if the user can view & edit macros