+ Reply to Thread
Results 1 to 5 of 5

Fix a shape ("Rectangle 1") to the top left hand side of the screen

  1. #1
    Registered User
    Join Date
    07-14-2014
    Location
    glasgow
    MS-Off Ver
    MS 365
    Posts
    39

    Fix a shape ("Rectangle 1") to the top left hand side of the screen

    Hi there, I'm looking for some help please.

    I would like to set a shape ("Rectangle 1 ") so it will stay fixed in the top left hand corner of the screen and stay fixed and fully viable while scrolling up, down, left and right...

    I tried a couple of different ways but had no luck.

    Is this possible..

    Thanks, Sean

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Fix a shape ("Rectangle 1") to the top left hand side of the screen

    You could freeze panes and put it above and left of the freeze. Otherwise, you'd need a userform.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-14-2014
    Location
    glasgow
    MS-Off Ver
    MS 365
    Posts
    39

    Re: Fix a shape ("Rectangle 1") to the top left hand side of the screen

    I've tried both these methods and they didn't quite give me the desired result.

    While the box stayed at the top left, I want the rest of the sheet to move up and down, side to side freely and I want the rest of the sheet to remain free to edit.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Fix a shape ("Rectangle 1") to the top left hand side of the screen

    Got it.

    No can do.

  5. #5
    Registered User
    Join Date
    07-14-2014
    Location
    glasgow
    MS-Off Ver
    MS 365
    Posts
    39

    Re: Fix a shape ("Rectangle 1") to the top left hand side of the screen

    Thanks.

+ 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. [SOLVED] Split screen "side by side" displaying wrongly
    By Trebor777 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2018, 10:28 AM
  2. [SOLVED] how to remove right rectangle on left side of the cell
    By hktom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-05-2015, 04:46 AM
  3. [SOLVED] How to remove all Zero"0" & space from left side
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2013, 05:37 AM
  4. Position Userforms on the Right Hand Side of screen
    By ben_patto in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2009, 01:10 AM
  5. [SOLVED] HOW TO DELETE WORKBOOKS IN EXCEL LISTED ON RIGHT HAND SIDE?":
    By glt45 in forum Excel General
    Replies: 1
    Last Post: 06-19-2006, 04:37 AM
  6. Replies: 1
    Last Post: 03-13-2005, 01:06 PM
  7. y-axis moves from the left hand side to the right hand side!
    By JP in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-10-2005, 09:06 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