code to display an Excel sheet (vba) Solved

Question

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

gbinforme · Accepted Answer

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

lermite222 · Answer

Hello,
Or if it's to hide them,

 Sheets("Sheet1").Visible = False 'And to make it visible... Sheets("Sheet1").Visible = True

See you later

--
Experience teaches more surely than advice. (André Gide)
If you bump into a pot and it sounds hollow, it's not necessarily the pot that's empty. ;-)(Confucius)

purspirit · Answer

Thank you very much for these two answers.

Code to display an Excel sheet (vba)

3 réponses

Canon mb5350 - cartridge replacement impossible

Texture issues in enshrouded

How to access the bios

[freebox] what customer service after lightning strike?

Code 3 chiffres pour tv grandin

Reading issues on d-jix m450

Disk reading impossible!!

Wii fit / wii synchronization issue

My livebox is no longer detected

Magic game encyclopedia