+ Reply to Thread
Results 1 to 2 of 2

Need code/macro/project for encryption/decryption worksheet

  1. #1
    Registered User
    Join Date
    09-10-2016
    Location
    America
    MS-Off Ver
    2016
    Posts
    9

    Need code/macro/project for encryption/decryption worksheet

    Hello Gurus,
    I have an Excel workbook that i've been working on. With the help from a couple members on this forum, it's running like I had envisioned it too. I now would like to make it look and act more like an application. Could someone help me out with this? I have attached the workbook. Basically, when the workbook is opened, I would like to have three buttons (ENCRYPT DECRYPT and PRINT TABLE ) when the ENCRYPT button is clicked, I would like a box to open that has:

    "Enter PlainText:" *User would then enter plaintext*
    "Enter Cipher Key:" *User would enter the key text*
    *button to click that says "ENCRYPT"*
    when clicked: "Encrypted text:" *encrypted text is shown*

    It would do the same when the DECRYPT button is clicked, but would decrypt instead of encrypt the text.

    The PRINT TABLE button would only open the REF worksheet to let users print the encryption table if they wanted. I'd like the REF tab hidden if possible as well.

    I've unlocked and cleared any passwords and protection I had on it. You can figure out how it works as is. The REF tab is usually hidden from the user. On the REF tab there is a chart that the formulas reference when doing the encryption and decryption work.

    If this is too much to ask, I understand, if not Thank you in advance!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-10-2016
    Location
    America
    MS-Off Ver
    2016
    Posts
    9

    Re: Need code/macro/project for encryption/decryption worksheet

    Anyone care to take a stab at this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Function that concatenates multiple sub-project descriptions based on project code
    By markbpi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 06:49 PM
  2. Decryption of a basic encryption
    By BENGREEN1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2012, 01:29 PM
  3. [SOLVED] Saving changes to macro code creates new VBA project in doc instead
    By nickc123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2012, 06:13 AM
  4. If i entered any project code in sheet2 display all data of that project
    By koolguys4u in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2009, 03:09 AM
  5. Code to make macro aletr VBA project.
    By Ranjani in forum Excel General
    Replies: 2
    Last Post: 04-03-2009, 12:58 PM
  6. Windows Encryption Code not working with Userform
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2006, 06:30 PM
  7. Replies: 1
    Last Post: 10-18-2005, 11:05 AM
  8. Encryption of Data in an Excel worksheet?
    By HardRockMiner in forum Excel General
    Replies: 0
    Last Post: 10-14-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1