Restricting Macros

[Pedroluna]

I created a Macro to do some copying and pasting. Can I restrict that Macro so that it can only be used from my PC?

[royUK]

You can but why would it be necessary? You would need to add code to obtain something unique like the hard drive serial number or possibly the computer name.

[Pedroluna]

The macro copies information into (sensitive) files read by Management. I could create a separte macro file and place it in my hard drive but then it would not be back up. I mostly want to keep others from changing/running the Macro. I tried restricting the file but it does keep others from running it only changing it. I can keep others from opening the file altogehter by password protecting it. Short of that what are my alternitives?

[shg]

You could keep your macro in Personal.xls, which you can (and should) back up periodically. My Personal.xls includes this:

Please Login or Register  to view this content.

I run it each time I add or delete something.

[royUK]

You could get your computer name & then write code to check the PC running the code against the name of your PC. If it is different then stop the code.

This will get your PC' name

Please Login or Register  to view this content.

Once you know the name then

Please Login or Register  to view this content.

[Pedroluna]

I like the last code w/If Environ("COMPUTERNAME") <> MyPc Then Exit Sub.

I tried it and works great.

Thanks,

[shg]

Just a caution: It would take someone about five seconds to change their computer name and run the sub.

Checking the drive serial number would be much more secure. And either way, you need to protect the VBA project.