the workbook as eleven sheets named Sheet0 to Sheet10. cell A1 in Sheet0 has value 0 when the value in cell A1 is changed to any number from 1 to 10, i want particuar sheet to be opened. when the value is 1, Sheet1 should be opened, when the value is 2, Sheet2 should be opened, and so on and so forth.
please help me with the macro. thanks.
Bookmarks