×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Macro Password

Macro Password

Macro Password

(OP)
Howdy,

I've come across an old SW macro in our company files that our CAD administrator would like to reactivate. Unfortunately it's set up in a way that requires a password to edit it. I've never run across this before. I can't believe somebody put a password on an open source (.swp) file. I can open it with NotePad++, but can't seem to find the password part of the code.

Does anybody know a way around or do I just start over?



Tobin Sparks
www.nov.com

RE: Macro Password

I can certainly believe it.  You don't want people screwing up your code, especially if it's used in a production type environment.  I have a couple of Excel spreadsheets with password protected code in them.  

Unfortunately, I believe you're probably SOL unless you can find (and trust!) a VBA password recovery software package.  It's possible you might be able to find someone on Tek-Tips that already has such a utility, but I'm not so familiar with that community.

-handleman, CSWP (The new, easy test)

RE: Macro Password

(OP)
handleman,

Thanks for your reply. I've thought about somebody changing the code before. I've taken only minor measures to keep track of this. I have all my released macro files in a network folder that only I (and IT) have access to. Anyone can change anything they want, but, can't blame me for it :-) . It's a shame we have to think about somebody doing something malicious.

Thanks Again

Tobin Sparks
www.nov.com

RE: Macro Password

I certainly didn't intend to imply any malicious intent on the part of my co-workers here.  However, well-meaning bumbling incompetence often causes the same level of damage!  winky smile

-handleman, CSWP (The new, easy test)

RE: Macro Password

(OP)
handleman,

LOL smile , point taken. Not intentionally malicious, of course smile .

Tobin Sparks
www.nov.com

RE: Macro Password

(OP)
usiko,

WOW!!! - Thank you very much!!! - that's very helpful. You'll probably have to change your name after this though smile .

Thanks Again

Tobin Sparks
www.nov.com

RE: Macro Password

"Weapons Grade Uranium"???

Seriously???

-handleman, CSWP (The new, easy test)

RE: Macro Password

I could use help with a password-protected macro.  I purchased PropertyList from Kent Contract for $20.  Whenever his website closed, the macro quit working.

His website is the 9th one down on the second list, and you will see that the link is now dead and for sale:
http://www.eng-tips.com/faqs.cfm?fid=118

That said, can someone remove the password to this macro?

Flores

RE: Macro Password

(OP)
OOPS!!! Didn't know this would start something! Sorry!

Tobin Sparks
www.nov.com

RE: Macro Password

(OP)
fcsuper,

I'm sure everybody would agree with you. It was also was written a few years ago and can be simplified. I'm supposed to fix it smile .

Thanks

Tobin Sparks
www.nov.com

RE: Macro Password

(OP)
fcsuper,

LOL LOL LOL - Yes - I'll replace it - just don't tell anybody smile . I'm thinking I've been asked to "fix" it because somebody thinks that will save time smile . Yeah right smile .

Thanks

Tobin Sparks
www.nov.com

RE: Macro Password

Tobin,

Just tell them that while you were fixing it, you renamed it RigidCustomProperties.  LOL

Joe
SW Office 2006 SP5.1
P4 3.0Ghz 1GB
ATI FireGL X1

RE: Macro Password

(OP)
JMarv,

Very Nice - Not sure I could tell him that with a straight face smile .

Thanks

Tobin Sparks
www.nov.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources