signature

  1. Alice Morland

    How do we add a signature to our posts?

    Hi all, I've read the sticky post about signatures, buuuut the Signature bit doesn't seem to be in the Settings section anymore. Can anyone suggest how to add one, please? Thanks! Alice
  2. B

    Better solution to vba sendkeys method for adding signature lines to word or excel

    Hi, I need to add a signature block and I have the code below. However it brings up a dialog box where you have to press enter to make it go away and it will add the signature and details. I need to bypass the dialog box which it doesnt seem possible so instead I was thinking of using sendkeys...
  3. T

    Setting up a Signature field to lock only certain fields?

    Background I have a .xlsm excel spreadsheet. Grids are overlaid on the form in such a way that each relevant field box can have data inputted into it. I also have TWO signature fields, one for the party that is sending the form out, the other for the people that are receiving the form. Question...
  4. B

    Adding Signature to the end of Word document and sign it

    I am working on some code in excel vba and trying to open a word document, then add a signature to the bottom, sign it, then export it as as pdf. So far here is what I have: Sub ExportSignedPDF 'Open Word Doc Dim WordApp As Word.Application Dim WordDoc As Word.Document Set...
  5. D

    Signatures

    How do u make a signature? it says sorry, you are nor eligible or something like that?
  6. O

    Hyperlink mailto concatenate body new line signature

    Hi, I'm trying to click a hyperlink that will open a new e-mail with Outlook and the e-mail would be all filled with values from Excel cells. Here's what I got so far: =HYPERLINK("mailto:" & R1530 & "?subject="& CONCATENATE(A1530," ",B1530) & "&body=" & CONCATENATE("HI","YO",C1530)&"hello"...
  7. R

    Please help.. VBA to add default outlook signature

    Please help wherein i want to add the outlook signature using VBA macro.. Can someone help me on this.:)
  8. N

    Send HTML email through Excel and Outlook 2016 with default signature

    Hello everybody, OK, here's the thing, I know how to send the email, problem is, when I try to add the DEFAULT signature. If I leave it as is, the body doesn't show up, and when I get it to show the body of the message, the signature won't come up. Sub Mail1() Dim...
  9. N

    email through excel

    Hello All, I am struggling with my email macro. I found a great one online that attaches a worksheet as a PDF as I need it to, but cant get the body right. I need certain items in the body to be bold and underlined. After doing some research it seems the only way to accomplish this...
  10. V

    How to insert signature in cell using userform

    Hi! I'm trying to create a Userform with an inkpicture field (for writing the signature), a command button (to enter said signature into sheet), and another command button to clear the inkpicture field. I want to insert the signature in the current active cell and automatically resize it to fit...
  11. S

    Digital Signatures

    Hello there! Is there a way to permanently save the signature setup information so I don't have to keep reentering the same information over and over again? Every time I have to keep filling out the below fields. I want to be able to sign off on a document instantly. I will likely be signing...
  12. C

    Signature Capture. Time Stamp.

    I have a document that I want to be signed twice. I know on Excel you can have a signature line but once you sign that once, the file is final and can't be edited without removing the signature line. How else can I capture two signatures?? If I could also have a cell auto populate the date and...
  13. A

    Reply All with Email History and Copy Original Attachments

    Dear Mr. Excel, I have the following codes that attempt to do the following, once an email is selected in MS Outlook: Include all the recipients in the selected email Copy the original attachments that came in the selected email Reply with a designated text, along with default signature and...
  14. K

    Return from addin form

    I am using a addin form for signature on excel sheet I press done command button after signature is inserted in worksheet the addin form is unloaded but it unloads all vba projects I am trying to return to main form. If I put in code before OLEObjects.add which puts signature on worksheet it...
  15. J

    Use VBA to replace variable in Outlook

    I'll do my best to explain what I would like to accomplish but I have zero experience with VBA and I haven't been able to piece together anything that works. I use Outlook 2010 and I have several different signatures. I have HTML and plain text versions of each signature so the VBA code needs...
  16. T

    Signature lines won't transfer with via

    I have a worksheet in workbook1 that complies information for the other worksheets and at the end of the day I need to export that specific worksheet to another workbook. So far I have no problem doing this, but the signature lines (8 total in a specific cell range) that I have there are not...
  17. T

    VBA to delete specific objects in worksheet

    :confused:I am having trouble creating VBA to delete specific objects in a worksheet before I copy that worksheet to a new workbook. I have several macro buttons and signature blocks in worksheet1 and when I click my export button I need the macro buttons to go away but the signature blocks to...
  18. K

    Item List - Properties/Qualities

    Good afternoon, I am curious if there is a reference tool that would provide all of the options available in a specific reference library. For example please see the code below. You'll notice that it says 'or use .Display.' I know from previous macros, you can also use .Save as well. However...
  19. M

    Macro to paste in outlook but keep the default signature

    I use the following code to copy a range of cells and paste it as an image into a new email: Sub Email() 'Copy range of interest Dim r As Range Set r = Range("A1:E24") r.Copy 'Open a new mail item Dim outlookApp As Outlook.Application Set outlookApp = CreateObject("Outlook.Application") Dim...
  20. J

    VBA Code to Select Pen/Draw or inkpicture

    Have been playing with signature boxes, etc. Would like to use the inkpicture feature but don't like the active x turned on. If you feel this is the better option and I can turn the active x message off with code when workbook opens, then feel free to share. I'd at least like VBA code to select...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top