EXCEL Macro to HIDE or SHOW all Charts VBA

Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.

Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat.

Nou pe simpatie:
beatrice17 din Bucuresti

Femeie
24 ani
Bucuresti
cauta Barbat
24 - 80 ani

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Macro to HIDE or SHOW all Charts [VBA]

Moderat de TRaP, TonyTzu

Autor

Mesaj

Pagini: 1

TonyTzu
Moderator

Inregistrat: acum 12 ani
Postari: 252

Create these 2 macros (modules) in the PERSONAL.XLSB file to make them available in all excel files:

HIDE

Sub HideAllShapes()
Dim sObject As Shape
For Each sObject In ActiveSheet.Shapes
sObject.Visible = False
Next
End Sub

SHOW

Sub ShowAllShapes()
Dim sObject As Shape
For Each sObject In ActiveSheet.Shapes
sObject.Visible = True
Next
End Sub

Source:

pus acum 6 ani

Pagini: 1

Mergi la