kJeune membrekobibh2Inscrit le :09/07/2019Dernière activité :21/12/2020 à 13:28Messages12Votes0Fichiers0Téléchargements0SujetsMessagesStatistiquesVotes reçus Messages postés par kobibh2DateAuteur du sujetSujetExtrait du message19/05/2020 à 08:06kobibh2Send email with VBAJ'ai un tableau avec la liste des noms des employés et leur liste de diffusion et les données qui changent chaque mois. J'ajoute des colonnes pour chaque mois supplémentaire et je ne supprime pas. Je souhaite envoyer à chaque employé un e-mail avec les données pertinentes pour ce mois uniquement et...06/08/2019 à 15:31kobibh2 Text align to the rightThis is the result two things: The first, variable "sendTo" goes down a line, it should be in the first row. Second, except for the first line the rest of the text is still on the left. Begins to despair. Attached print screen Thank you...06/08/2019 à 11:52kobibh2 Text align to the rightUnfortunately the code not compile. can you add the file that you work on...06/08/2019 à 09:45kobibh2 Text align to the rightGood morning Steelson and else I join a file be attention that the first row align to the right, and the "SendTo" variable need to be in the same row The name of the macro :"RDB_Worksheet_Or_Worksheets_To_PDF_And_Create_Mail" The relevant line of code is in line 59 TY again...05/08/2019 à 13:45kobibh2 Text align to the rightFirst TY Unfortunately I was unable to complete what you recommended (I only succeeded on the title). I would be happy if you could fix it. StrBody:="<H3><B> in honor of </B></H3><br>" & SendTo & _ "<body> TEXT TEXT TEXT TEXT " & _ "<br><br>" & " End o...05/08/2019 à 11:07kobibh2 Text align to the rightI have a VBA code for sending an Excel sheet as a PDF. To the file I add text. I have a problem with the text because I need it to be on the right (Hebrew language). After an extensive search on the Internet I did not find a solution. I would appreciate your help, Kobi That's part of the code...25/07/2019 à 12:47kobibh2Custom function...25/07/2019 à 12:19kobibh2Custom functionMy mistake Now I saved as an XLAM file. Does the file need to be opened to use the function in other files...25/07/2019 à 10:49kobibh2Custom functionI wrote a custom function and I want it to work on any Excel file that I open. How can this be done? From an inquiry so far I understood that you can save as an XLMA file only that I could not Thanks to the respondents...09/07/2019 à 12:52kobibh2 Lock the cells with the formulasKing...09/07/2019 à 10:24kobibh2 Lock the cells with the formulasThanks Vince1512 for the quick response! I do not want to enter a password in the box. For example the password is "A1B2" - my intent is a permanent password for all sheets...09/07/2019 à 10:06kobibh2 Lock the cells with the formulasI would like to help, I need a VBA code to protect cells with formulas and will then lock the sheet with a password. So far I've been able to write code that goes through all the sheets in the file and lock the cells with the formulas. For password protection I could not Thanks to the tortured. This...Forums