View Single Post
 
Old 08-24-2013, 05:31 AM
JTS JTS is offline Windows 8 Office 2013
Novice
 
Join Date: Aug 2013
Posts: 2
JTS is on a distinguished road
Default 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
Reply With Quote