![]() ![]() If the text typed into the user form is true, Sheet #2 is activated. Having read that there were password problems in 2013, I decided to change the user form to confirm a password using a TRUE/FALSE statement in Sheet #1. When the button was clicked, it would not take the password, but it would take the password for sheet #1, which told me that either the passwords got scrambled or sheet #1, which was now hidden, was in fact still the active sheet. Originally the User Form selected Sheet #2, which had a button to unprotect it. Sheet #2 (Maint_Menu) is only for the manager to update data. When I go back to Sheet #1, the data I typed in is now there. ![]() What happens is that when I type data into a cell in Sheet #2, I can see it in the formula bar but it disappears when I hit ENTER or TAB and the original data is remains in the cell. But I think it is just the sheet's "window" is visible, because sheet #1, appears to actually be the active sheet even though I have hidden the sheet and am looking at Sheet #2. When I activate a 2nd sheet via a user form, the 2nd sheet is now visible. Last week I was at a client's location 1,000 miles from home and spent quite a bit of time trying to find the solution. #Activate solver in excel 2013 youtube install#Unfortunately I do not have access to a computer running 2013 and don't want to purchase it or install it due to many the many problems I have read about. I have several computers running Excel 2003, 20. Has anyone seen such behaviour? If yes, are there any coding workarounds to properly activate Sheet2? I tried also with Activate method instead of Select, same result, works fine for older Excel version, doesn't work with 2013.Ĭlicking back from Sheet1 to Sheet2 worksheet activates the Sheet2 sheet properly. 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: ![]() #Activate solver in excel 2013 youtube how to#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 |