Please help me how to make a protection to lock excel sheet to work only in
certain PCs.
When opening a worksheet it could be in a auto_open code and check for
example MAC-address of the PCs lan adapter.
After comparing allowed MAC-addressed macro should then either close sheet
or allow it to be opened.
If its hard to lock to MAC-address, anything else check will do fine, this
protection isn't intended for the profesionals, only for normal endusers.

Jason

This will get you the MAC address
http://vbnet.mvps.org/code/network/macaddress.htm

NickHK

"Jasoni" wrote in message
...
Please help me how to make a protection to lock excel sheet to work only
in
certain PCs.
When opening a worksheet it could be in a auto_open code and check for
example MAC-address of the PCs lan adapter.
After comparing allowed MAC-addressed macro should then either close sheet
or allow it to be opened.
If its hard to lock to MAC-address, anything else check will do fine, this
protection isn't intended for the profesionals, only for normal endusers.

Jason

Thank You very much for the quick answer.
Now I only have to learn how to use it ;o)
Looks little bit complicated for my VBA level but lets see....
Thanks



"NickHK" kirjoitti
...
This will get you the MAC address
http://vbnet.mvps.org/code/network/macaddress.htm

NickHK

"Jasoni" wrote in message
...
Please help me how to make a protection to lock excel sheet to work only
in
certain PCs.
When opening a worksheet it could be in a auto_open code and check for
example MAC-address of the PCs lan adapter.
After comparing allowed MAC-addressed macro should then either close
sheet
or allow it to be opened.
If its hard to lock to MAC-address, anything else check will do fine,
this
protection isn't intended for the profesionals, only for normal endusers.

Jason

"NickHK" kirjoitti
...
This will get you the MAC address
http://vbnet.mvps.org/code/network/macaddress.htm

NickHK


Everything worked just fine, no problem.
Thanks once more.

Should be a case of copy/paste, although it is always better to understand
the code you are using.
The only section to change would be

Private Sub Command1_Click()
'in calling, pass the character you
'want as a delimiter between MAC
'address members
Text1.Text = GetMACAddress("-")
End Sub

NickHK

"Jasoni" wrote in message
...
Thank You very much for the quick answer.
Now I only have to learn how to use it ;o)
Looks little bit complicated for my VBA level but lets see....
Thanks



"NickHK" kirjoitti
...
This will get you the MAC address
http://vbnet.mvps.org/code/network/macaddress.htm

NickHK

"Jasoni" wrote in message
...
Please help me how to make a protection to lock excel sheet to work
only
in
certain PCs.
When opening a worksheet it could be in a auto_open code and check for
example MAC-address of the PCs lan adapter.
After comparing allowed MAC-addressed macro should then either close
sheet
or allow it to be opened.
If its hard to lock to MAC-address, anything else check will do fine,
this
protection isn't intended for the profesionals, only for normal
endusers.

Jason