Ad Clicks :Ad Views : Ad Clicks :Ad Views : Ad Clicks :Ad Views : Ad Clicks :Ad Views :
    Excel formulas and tutorials

    Excel formulas and useful tools

    Category: VBA

    img

    VBA macro print as PDF

    By
    |
    In VBA
    |
    On February 22, 2018
    A very helpful VBA macro that turns any printable excel document into a PDF file. Convert excel to pdf or save excel to pdf Sub savepdf() mo= Month(Date) d = Day(Date) y = Year(Date) h = Hour(Now) m = Minute(Now) s = Second(Now) file= y & mo & d & “-” & h & m […]

    Run macro on open file event

    By
    |
    On October 14, 2016

    In order to run macro on open file event you need to have the VBA code (macro) inside the Workbook_Open() event in ThisWorkbook element on Project Explorer. You must first open the VBA editor in Excel

    img

    Excel VBA Macro

    By
    |
    In VBA
    |
    On October 12, 2016
    This is a tutorial for anyone wanting to learn how to write their first excel vba macro. These macros are very useful when we need to do a lot of manual work on large data tables and these manual actions can be automated by using a macro to execute every operation that we usually did […]
    img

    Excel file unsaveable

    By
    |
    In VBA
    |
    On May 8, 2014
    Some companies use Excel files through intranet networks for all their staff to have access to certain information and automated reports. This usually means that this kind of file should be unsavable by the staff in order to preserve a certain degree of accuracy and format. Setting Excel file as unsavable Without altering the menu […]
    This div height required for enabling the sticky sidebar
    <