How to hide a table in excel without resizing the chart

Asked

Viewed 65 times

0

I would like to hide a table but it feeds a graph, I would like to do this without resizing the graph. This chart uses selection buttons that have been formatted with macros.

excel excel-vba

  • If this table is filled with data coming from some program, Voce can leave the tab that this table belongs hidden and in the program just pass the file path and tab you want to access. See more at https://usuariosdoexcel.wordpress.com/2011/06/30/controlando-acesso-planilhas-via-vba/ https://www.guiadoexcel.com.br/formulario-vba-excel-de-navegacao-entre-planilhas/

  • The chart and table are in the same tab on each other and I would not like to create another tab just for a table.

1 answer

0

One option is to use an event in the tab to resize the chart. I opted for the Selectionchange event. Follow the suggestion:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

With ActiveSheet.ChartObjects(1)
         .Height = 325 'ajustar para tamanho desejado
         .Width = 500 'ajustar para tamanho desejado
End With

End Sub

If you need an introduction to events in VBA, follow the suggestion: http://www.jorgepaulino.com/2009/09/excel-dicas-de-vba-eventos.html

Browser other questions tagged excel excel-vba

You are not signed in. Login or sign up in order to post.