Freelancer: wtreymacyucy
Compartilhar:
Denunciar Inscrição

VBA macros in excell Workbook + hide/print button

VBA macros in excell Workbook with buttons to hide the empty rows and print button. The sheet name - when changesd, is automatically transfered to the section name and to the Sales proposal. The responsible person name can be selected from a list in the Data sheet.

Inscrição nº 5 do Concurso para Excel File to Build Proposals
Inscrição nº5

Painel de Esclarecimento Público

  • wtreymacyucy
    wtreymacyucy
    • 4 anos atrás

    Hello. After downloading the file i have sent you there are two more things that need to be done:
    1. If you want to generate a pdf report after creating the proposal, you must install a Microsoft Office add-in which allows to create PDFs from excel. The download link if you are using Excel 2007 is http://www.microsoft.com/en-us/download/details.aspx?id=9943
    (if you are using a different version of excel you should search the Microsoft page for the appropriate version of the PDF Add-in)
    One you have downloaded the add-in you can generate the PDF of the Sales Proposal simply by clicking the Create PDF button.

    2. In order to use the macros assigned to the buttons you must click the Options button on the Security Warning button and select "Enable this content"

    I have also created in each Sales sheet 2 buttons to increase easiness in navigation to the Data Sheet and to the Proposal Sheet.

    Feel free to contact me for any necessary information.
    Best regards.
    Lucian.

    • 4 anos atrás