View original (French)

Code to display an Excel sheet (vba)

Solved
purspirit Posted messages 14 Status Member -  
purspirit Posted messages 14 Status Member -
Hello,
I am a beginner in Excel programming and I want to create an application.
My question for now:
How do I create a command to display an already existing worksheet?
And how do I close it?

Thank you in advance for your help.
Configuration: Windows XP Internet Explorer 6.0

3 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello

    how to create a command to display an already existing spreadsheet?

    Sheets("my_sheet_to_display").activate

    and how to close it?

    Sheets("another_sheet_to_display").activate

    --

    Always calm
    18