simone8989, 20/04/2021 12:57:Salve a tutti, nel file allegato nella colonna G2:G109 vorrei trovare i valori corrispondenti presi dalla tabella A2:B7899 . Grazie mille
Private Sub Workbook_Open() Dim i As Integer Worksheets("Italia").Protect "123", UserInterfaceOnly:=True Worksheets("Province").Protect "123", UserInterfaceOnly:=True Worksheets("Comuni").Protect "123", UserInterfaceOnly:=True Sheets("Province").Visible = True Sheets("Comuni").Visible = True For i = 2 To Sheets.Count Sheets(i).Protect "123", UserInterfaceOnly:=True Sheets(i).Visible = True Next End Sub
Private Sub Workbook_Open() Dim i As Integer Worksheets("Italia").Protect "123", UserInterfaceOnly:=True Worksheets("Province").Protect "123", UserInterfaceOnly:=True Worksheets("Comuni").Protect "123", UserInterfaceOnly:=True Sheets("Province").Visible = xlVeryHidden Sheets("Comuni").Visible = xlVeryHidden For i = 2 To Sheets.Count Sheets(i).Protect "123", UserInterfaceOnly:=True Sheets(i).Visible = xlVeryHidden Next End Sub
simone8989, 20/04/2021 14:51:Ciao Alfredo, in effetti a me serve estrarre i valori corrispondenti dei comuni della colonna G presi dalla colonna A . Grazie