none
A way to convert Excel to an exe file RRS feed

  • Question


  • Hi
    My project is finished and it has multiple sheets
    But now I'm just working with one sheet
    Can it be Convert the project to an exe file?

    Or at least,
    The user does not change macros and cells when working with the program

    Regards,






    • Edited by kapriano Thursday, February 15, 2018 8:16 AM
    Thursday, February 15, 2018 8:03 AM

All replies

  • Hi kapriano,

    I'm afraid we cannot convert an Excel file to executable one. 
    I'm not sure if I can understand what you want to do. So, please let me confirm:
    Do you want to make Excel macro which users cannot modify, and where users cannot change cell value?

    Would you provide more details about what you want to do?

    Regards,

    Ashidacchi

    • Edited by Ashidacchi Thursday, February 15, 2018 8:58 AM
    Thursday, February 15, 2018 8:57 AM
  • Hi

    If it does not to exe
    At least

    I want only 1 sheet visible
    Just the one I work with
    I hide the sheets, but the macros make errors when converting to PDF

    Regards,

    Thursday, February 15, 2018 10:54 AM
  • Hi kapriano,

    I'm afraid you must use a wrong word "PDF". PDF stands or "Portable Document Format".
    If you have macro, please provide it. Otherwise, sorry, I cannot understand what you want to do. 

    Regards,

    Ashidacchi

    • Edited by Ashidacchi Thursday, February 15, 2018 11:07 AM
    Thursday, February 15, 2018 11:02 AM
  • Hi,

    I guess you want to make a print image that users cannot modify it.
    If this is correct, open your Excel file and select one sheet (you want to show to users) and print to PDF. Then you can protect that PDF file with password.
    (You can do these steps manually, without any Macro.)

    Regards,

    Ashidacchi


    • Edited by Ashidacchi Thursday, February 15, 2018 11:19 AM
    • Proposed as answer by WillVelez2 Thursday, February 15, 2018 12:55 PM
    Thursday, February 15, 2018 11:17 AM
  • No
    this is not my mean

    The Excel project at the end gives you a print of the worksheets
    But when I hid the sheets
    Macro makes a error

    This!!!

    Thursday, February 15, 2018 11:43 AM
  • Hi,
    I would like to say it again.
    You need to provide your macro (source code)... I'm afraid you misunderstand the meaning of macro.
    Regards,

    Ashidacchi



    • Edited by Ashidacchi Thursday, February 15, 2018 11:58 AM
    Thursday, February 15, 2018 11:46 AM
  • What should I do to do this?
    Thursday, February 15, 2018 12:05 PM
  • Hi kapriano,
    Sorry, I cannot understand what you want to do and what you are saying?
    You wrote: What should I do to do this? But you did not explain what "this" is.
    Regards,

    Ashidacchi

    Thursday, February 15, 2018 12:52 PM
  • Hello Kapriano,

    According to your description, it seems that you want to edit data in a sheet and then print it out.

    However, you want to ban use to edit data in the sheet manually, so you hide the sheet. And this caused the print error, right?

    Have you ever tried to unhide the sheet in code temporarily and hide it again after printing?

    Best Regards,

    Terry

     


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, February 22, 2018 2:34 AM