wenn deine Daten auf "Tabelle1" stehen, kannst Du mit folgendem Makro die Spalten "B","C" und "F" ausblenden
Code: Alles auswählen
Sub hide_Columns
osheet = Thiscomponent.sheets.getbyname("Tabelle1")
aC = array("B","C","F")
for i = 0 to ubound(aC)
oC = osheet.columns.getbyname(aC(i))
oC.IsVisible = false
next i
end Sub
Code: Alles auswählen
Sub show_Columns
osheet = Thiscomponent.sheets.getbyname("Tabelle1")
aC = array("B","C","F")
for i = 0 to ubound(aC)
oC = osheet.columns.getbyname(aC(i))
oC.IsVisible = true
next i
end Sub
HTH R