LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 86
Default A simple question for anyone but me

I have a button on the main data sheet that should open a chart sheet full
screen. When the user closes the full screen, it should go back to the data
sheet, not the chart sheet. Here is the code I have.

Sub showChart1()
Sheets("Chart1Color").Select
Application.DisplayFullScreen = True
If Application.DisplayFullScreen = False Then
Sheets("SideBySide").Select
End If
End Sub

From the SideBySide sheet, it does open up Chart1Color in Full Screen,
however, when I close Full Screen, it stays on the Chart1 worksheet. How to
fix this, how to fix this...

And then, how can I put two charts side by side in 2 windows. I recorded
macros, I looked in the Help files, I'm not getting anywhere.

I appreciate your help.

Arlen
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
simple sum question smiley61799 New Users to Excel 1 April 21st 09 04:58 PM
IF formula-simple question; simple operator Rich D Excel Discussion (Misc queries) 4 December 6th 07 03:36 PM
Simple Simple Excel usage question BookerW Excel Discussion (Misc queries) 1 June 23rd 05 10:06 PM
simple question, hopefully a simple answer! Matt B Excel Programming 5 January 13th 04 08:43 PM
Simple VB question HammerHead Excel Programming 3 November 12th 03 07:36 PM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"