Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-24-2013, 05:31 AM
JTS JTS is offline Activate Worksheet with button in Excel 2013 Windows 8 Activate Worksheet with button in Excel 2013 Office 2013
Novice
Activate Worksheet with button in Excel 2013
 
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
  #2  
Old 08-25-2013, 12:02 AM
JTS JTS is offline Activate Worksheet with button in Excel 2013 Windows 8 Activate Worksheet with button in Excel 2013 Office 2013
Novice
Activate Worksheet with button in Excel 2013
 
Join Date: Aug 2013
Posts: 2
JTS is on a distinguished road
Default 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.
Attached Files
File Type: xlsm Worksheet Activate Example.xlsm (23.0 KB, 11 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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
Activate Worksheet with button in Excel 2013 VB Code in Excel Active worksheet shakilhyd Excel 2 05-17-2010 07:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft