+ Reply to Thread
Results 1 to 3 of 3

Chart axis resizing affecting full screen

  1. #1
    Registered User
    Join Date
    11-14-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    8

    Chart axis resizing affecting full screen

    Hi

    My workbook operates in full screen mode simly to make it looks a bit nicer. I have some + - buttons that call a macro to change the scale of the axes of a chart (sort of a zoom effect). For some reason, whenever I run these macros my workbook exits out of full screen mode. Why is this?

    Here's an example of the zoom code:

    ActiveSheet.ChartObjects("Chart 115").Activate
    ActiveChart.Axes(xlValue).Select
    ActiveChart.Axes(xlValue).MinimumScale = 200000
    ActiveSheet.Range("a1").Select

    Thanks

  2. #2
    Registered User
    Join Date
    11-14-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Chart axis resizing affecting full screen

    I've also just noticed that running this code makes the workbook open a seperate version of the active worksheet!?

  3. #3
    Registered User
    Join Date
    11-14-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Chart axis resizing affecting full screen

    Any ideas guys?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Resizing or Moving Chart Shapes and Screen Resolution
    By jubaitca in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-12-2012, 12:47 AM
  2. Replies: 4
    Last Post: 02-04-2011, 05:08 AM
  3. Replies: 1
    Last Post: 08-10-2009, 03:34 PM
  4. [SOLVED] Resizing Userform to screen size
    By Al@n in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2006, 05:30 PM
  5. [SOLVED] Screen resolutions and resizing forms
    By Ken Soenen in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-12-2005, 04:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1