Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TDugan
  • Content: Threads
  • Order by date
  1. TDugan

    Code to create fillable PDF from Word

    I have a word document that I manipulate what displays based on input from a userform. Once the code has generated the correct version of the document based on the inputs, I convert the word document to a PDF (also with code). Works fine. But, is there code that would create a fillable PDF...
  2. TDugan

    Protecting a Word Document from Excel with VBA code

    I have an excel VBA project and as part of that I launch a word doc and fill in information that was input on a userform in the excel doc(to prevent double-entry of data). The word doc has to be protected so that users can't alter the info. I have the word doc protected to start with...
  3. TDugan

    Delete Word ActiveX textbox with VBA code from Excel

    I have VBA code in excel and as part of that I launch a document in Word and populate ActiveX textboxes with information that was populated in the Excel userform. However, in some instances, I want the code to delete the ActiveX textbox instead of populating it. Can anyone tell me how to...
  4. TDugan

    Calculating a value based on a text field

    Hi, I have a userform in excel with a field called txtBenefitAmt. As part of my code, I have excel launch a word document and populate information given to me in the excel userform. The word document does not have a userform but I have txt boxes on the doc itself. However, in certain...
  5. TDugan

    Disable New Worksheet Function

    I need to prevent users from adding new tabs to an Excel worksheet that I have. I have added the following code to "ThisWorkbook". Private Sub Workbook_NewSheet(ByVal Sh As Object) MsgBox "New tabs are not allowed in the Plan Profile!", vbOKOnly, "New tabs not allowed"...
  6. TDugan

    Disable New Worksheet Function in Excel

    I need to prevent users from adding new tabs to an Excel worksheet that I have. I have added the following code to "ThisWorkbook". Private Sub Workbook_NewSheet(ByVal Sh As Object) MsgBox "New tabs are not allowed in the Plan Profile!", vbOKOnly, "New tabs not allowed"...
  7. TDugan

    Excel - Need to Hide a Picture

    In Excel, I am using code to hide rows in certain situations. The issue is that a picture I have in one of the rows isn't hiding like the text. I think I need to add code specifically for the picture, but not sure what syntax should be used. The Sheet is called "T404 Full". The...

Part and Inventory Search

Back
Top