![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
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 |
![]() |
shakilhyd | Excel | 2 | 05-17-2010 07:50 AM |