The Sheet2 worksheet is activated, sort of, but if I edit data in it, it actually updates corresponding cells in Sheet1, if I click on Sheet1 I can see data entered in there! ![]() On click of Button2 call Macro2 which has 1 line:Ī UserForm1 pops up and on click of a CommandButton1 call same Macro1 like this: I can edit data in Sheet2 fine in this situation. On click of Button1 activate Sheet2 worksheet using a Macro1 with 1 line in it: Have a workbook with 2 worksheets in it, called Sheet1 and Sheet2 let's say, and some different data in both sheets, in same cells, to observe the issue better, and on Sheet1 have 2 buttons: This is how to simply reproduce the issue: ![]() I have an issue with activating a sheet from a user form, the same code works fine in Excel 2003 to Excel 2010, doesn't work with Excel 2013.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |