help file

  1. J

    Dumb VBA question

    Hi there, I have started using Excel 2016 and have I have some code that switches off F1 Help in Excel: Private Sub Workbook_Open() Application.OnKey “{F1}”, “” End Sub However when I open the Personal workbook, ThisWorkbook, the middle line is highlighted red. Anyone have any...
  2. Wessie

    Opening a PDF document from within an Excel file

    Hi all I have a quick question that is puzzling me. I want to attach a PDF help file on an Excel file / sheet / workbook that is fully portable. I want to program a button on a userform that will open this PDF document, and if possible, make the PDF file accessible if you press the F1 help...
  3. K

    chm Help file for User-Defined Function

    I manage to display the chm help file to an User-Defined Function by clicking on the "Help on this function" in Insert Function dialog box. This was possible only when the my file is xlsm. After I saved the xlsm file as an xlam file (an addin) and installed the addin. The help file can be...
  4. P

    Help for custom functions in xl2010 windows8 server

    I have written a custom function with the signature: Function Contains(TestRange As Range, CriteriaRange As Range) As Long The function works with no problems. When I click the "fx" button to right of the range name box, a pop-up appears to allow me to select a function category...
  5. P

    Freeforms in VBA

    I have tried the freeformbuilder example in Excel VBA 2007. It works fine, however the help file cannot be correct since it is redundant. Go to the FreeformBuilder.AddNodes Method and look at the Description on the right. According to MS help, when using the msoEditingCorner, X1 and Y1 are the...
  6. P

    'developer reference' help window font size...

    hi all... I have excel 2007 and changed my screen resolution to (bigger) to view the help files. unfortunately with the ‘search scope’ set to ‘developer reference’ the font is tiny but with the other ‘search scopes’ the font size is bigger than before. I have changed the ‘font size’ button...

Some videos you may like

This Week's Hot Topics

Top