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
|