#1
|
|||
|
|||
Activate Worksheet with button in Excel 2013
Hi All.
Purchased a new laptop on Sunday, and had to purchase MS Office 2013 with it.After spending a lot of money on this, I have only been beyond frustrated thus far! From very complicated, to basic Excel sheets are now just posing problems. My current problem:All my Excel tools built with VBA have a Menu, and sheets are accessed via buttons on the Menu. I use the following basic code to access the sheets when the button is clicked: [code] Worksheets("Sheet1").Visible = True Worksheets("Sheet1").Activate Unload Me 'to unload the button [code] With Excel 2013 the sheet is made visible and activated as it should. Although my mouse cursor is shown on the activated sheet, all tasks I do on this sheet is done on the sheet where the original button was. If I for example scroll down or type data it happens on the original sheet, although I am viewing the new sheet. Hope someone can help! Thanks |
#2
|
|||
|
|||
Example of procedure not working in Excel 2013
Please find attached an example of the problem.
This basic Excel document works perfectly on all other versions of Excel. In Excel 2013 though, all changes effected once the new sheet is visible happens on the original Menu worksheet. I really hope someone with Office 2013 can also try this on their pc and give me some feedback. Kind Regards. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Paste special an Excel range into Outlook as an Excel Worksheet | charlesh3 | Excel Programming | 3 | 02-04-2013 04:33 PM |
Excel - Color Worksheet Tabs | avie layne | Excel | 4 | 11-12-2012 04:45 PM |
Excel 2010 slow update of worksheet | bosve73 | Excel | 2 | 03-28-2012 05:14 AM |
Distortion trying to embed excel worksheet | Sugaratias | Word | 0 | 11-26-2011 11:26 AM |
VB Code in Excel Active worksheet | shakilhyd | Excel | 2 | 05-17-2010 07:50 AM |