{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Maj_Onglets","art","09-12","10-12","11-12","12-12","01-13","02-13","03-13","04-13","05-13","06-13","07-13","08-13","Noms_"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Maj_Onglets","index":0,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[10,2,14,4]]}
[null,null,null,null,null,null,null,"Je cherche une macro qui puisse me changer automatiquement (en cliquant sur un bouton) l'année 2012 en 2013 et l'année 2013 en 2014. Ensuite changer l'année 2013 en 2014 et 2014 en 2015 ainsi de suite."]
[null,null,null,null,null,null,null,"Mais onglets fonctionneront toujours sur ce principe de deux années qui se suivent."]
[]
[]
[null,null,null,null,null,null,"a)","Exemple n°1",null,null,"Exemple n°2",null,null,"Exemple n°3"]
[null,null,null,null,null,null,null,"Avant","Après",null,"Avant","Après",null,"Avant","Après"]
[null,null,null,null,null,null,null,"2012-09-01","2013-09-02",null,"2013-09-01","2014-09-02",null,"2014-09-02","2015-09-02"]
[null,null,null,null,null,null,null,"2012-10-01","2013-10-02",null,"2013-10-01","2014-10-02",null,"2014-10-02","2015-10-02"]
[null,null,null,null,null,null,null,"2012-11-01","2013-11-02",null,"2013-11-01","2014-11-02",null,"2014-11-02","2015-11-02"]
[null,null,null,null,null,null,null,"2012-12-01","2013-12-02",null,"2013-12-01","2014-12-02",null,"2014-12-02","2015-12-02"]
[null,null,"Un bouton sera créé",null,null,null,null,"2013-01-01","2014-01-02",null,"2014-01-01","2015-01-02",null,"2015-01-02","2016-01-02"]
[null,null,null,null,null,null,null,"2013-02-01","2014-02-02",null,"2014-02-01","2015-02-02",null,"2015-02-02","2016-02-02",null,"Normalement, je fonctionnerai sur 12 onglets "]
[null,null,null,null,null,null,null,"2013-03-01","2014-03-02",null,"2014-03-01","2015-03-02",null,"2015-03-02","2016-03-02",null,"mais je pourrais en avoir plus de 12 ou moins de 12 fonctionnant "]
[null,null,null,null,null,null,null,"2013-04-01","2014-04-02",null,"2014-04-01","2015-04-02",null,"2015-04-02","2016-04-02",null,"toujours sur le même principe."]
[null,null,null,null,null,null,null,"2013-05-01","2014-05-02",null,"2014-05-01","2015-05-02",null,"2015-05-02","2016-05-02"]
[null,null,null,null,null,null,null,"2013-06-01","2014-06-02",null,"2014-06-01","2015-06-02",null,"2015-06-02","2016-06-02"]
[null,null,null,null,null,null,null,"2013-07-01","2014-07-02",null,"2014-07-01","2015-07-02",null,"2015-07-02","2016-07-02"]
[null,null,null,null,null,null,null,"2013-08-01","2014-08-02",null,"2014-08-01","2015-08-02",null,"2015-08-02","2016-08-02"]
[]
[]
[null,null,null,null,null,null,null,"Je recherche également une autre macro ou sur la même macro qui puisse également me modifier les onglets s'ils se présentent sous cette forme."]
[]
[null,null,null,null,null,null,null,"Exemple n°1",null,null,"Exemple n°2",null,null,"Exemple n°3"]
[null,null,null,null,null,null,"b)","Avant","Après",null,"Avant","Après",null,"Avant","Après"]
[null,null,null,null,null,null,null,"1TR-12","1TR-13",null,"1TR-13","1TR-14",null,"1TR-14","1TR-15"]
[null,null,null,null,null,null,null,"2TR-12","2TR-13"," ","2TR-13","2TR-14",null,"2TR-14","2TR-15"]
[null,null,null,null,null,null,null,"3TR-12","3TR-13",null,"3TR-13","3TR-14",null,"3TR-14","3TR-15"]
[null,null,null,null,null,null,null,"4TR-12","4TR-13",null,"4TR-13","4TR-14",null,"4TR-14","4TR-15"]
[null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,"J'aurai dans chacun des 2 cas:"]
[]
[null,null,null,null,null,null,null,"1er onglet nommé \"Maj_Onglets\""]
[null,null,null,null,null,null,null,"2ème onglet nommée \"art\""]
[null,null,null,null,null,null,null,"Ensuite tous mes onglets nommés à cheval sur 2 années (voir a ci-dessus) ou les 4 trimestres de l'année (voir b ci-dessus)"]
[null,null,null,null,null,null,null,"Et enfin un onglet nommé \"Noms_\""]

{"sheet":"art","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"09-12","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"10-12","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"11-12","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"12-12","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"01-13","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"02-13","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"03-13","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"04-13","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"05-13","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"06-13","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"07-13","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"08-13","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Noms_","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}