encrypt

  1. K

    Decrypt aes-encrypted text file to be read in via Excel VBA

    Hi, I've got a text-file with aes-encrypted content generated by a software in use at my place. It contains a database name, an username and the corresponding password. In the software, the user can enter these parameters, establish a connection to the database (Oracle DB) and perform different...
  2. A

    How to link a value in excel workbook cell which is on Google Drive to Another workbook in google drive

    Hello there, Hopefully everybody is fine, I have planned a lot and structured the data for many hours and days, now I would like to know how I can link excel cell value of workbook1 to workbook2 in the case that they are in google drive because when I opened the other workbook is shows a...
  3. mathceleb

    Excel/VBA Unique code per file

    I have a macro which creates a new workbook. The goal is to have any file created from this workbook "tagged" so when we upload the file, the tag is recognized. If the tag does not exist, the upload is rejected. One idea I had was to use a SHA1 encryption code and plop it into a cell with the...
  4. M

    Encrypt Cells in a Worksheet

    I am trying to create a spreadsheet that contains personal sensitive information, in this case, Social Security Numbers. Individuals will be asked to enter information, including their SSN. However, I want the SSN to be automatically encrypted once the user fills in the number. The number...
  5. I

    Print to PDF with Encryption / Password VBA

    Morning, Please can someone help me with a Print to PDF Macro with a password specified from a cell. I'm really struggling with this! I have PDF Creator but any macro I try doesn;t work so far. "Dim.pdfjob as PDFCreator." is part of the problem, I only have the options "PDFCreatorOBj...
  6. L

    Mail Merge - Encrypt Multiple Files (possible?)

    Hi, We need to personalize a (.pdf) memo to multiple recipients, from a mail merge (source: excel data spreadsheet), and wish to have the individual memos encrypted since we plan to send the personalized memos via Outlook email-merge automatically. Has anyone accomplished this before? Each...
  7. R

    VBA Encryption

    I've been trying for countless hours and I can't figure it out. I have the below code for a UserForm in Excel. Everything runs as it should except that it refuses to actually encrypt the email. Anybody able to help? Private Sub Submit_Click() Dim OutApp As Object Dim OutMail As Object Dim...
  8. S

    Encrypting with VBA

    Hi, I am trying to make it so that a spreadsheet cannot be opened without a password after a certain date using VBA.. So far I have this Private Sub Workbook_Open() If Sheets(1).Cells(2, 2).Value <= Date And Sheets(1).Cells(2, 2).Value <= Date Then ActiveWorkbook.Protect...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top