+ Reply to Thread
Results 1 to 2 of 2

Lock right side of Window to prevent dragging it larger ....

  1. #1
    Registered User
    Join Date
    03-23-2015
    Location
    Pinetown, South Africa
    MS-Off Ver
    2013
    Posts
    9

    Lock right side of Window to prevent dragging it larger ....

    Hi.

    I have a spreadsheet containing a price list of some of our products, and to the right of the white pages which will be printed for the brochure I have columns in the grey area in which I do calculations which link to the white pages.

    Normally this would not be a problem, but we need to email the price list to various customers and we do not want them to see the grey area to the right of the white pages.

    Is there a way in which one can prevent the customer from dragging the right side of the window to show the grey area, and thus conceal this section from him ?

    In other words: lock the page to the white page view only.

    Thanks for your assistance.

    Patrick


  2. #2
    Valued Forum Contributor
    Join Date
    01-03-2016
    Location
    Conwy, Wales
    MS-Off Ver
    2016
    Posts
    974

    Re: Lock right side of Window to prevent dragging it larger ....

    Does the customer need an Excel file. Why not send him a PDF.
    Try this:

    Select the area you want the customer to see and click on "set print area"
    Then:
    Save As
    and select "PDF"

    the PDF will only contain the area selected

    (note you may need to tailor this in the same way as you would a normal printing job (header rows, fitting it to a single page wide etc)
    If a response has helped then please consider rating it by clicking on *Add Reputation below the post
    When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)

+ 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. VBA Script For Side By Side Window Arrangement
    By elliserr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-13-2014, 11:07 AM
  2. [SOLVED] Can not see Project Explorer in the left side and the Code window in the right
    By AB33 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-13-2012, 03:28 PM
  3. Replies: 3
    Last Post: 12-30-2011, 01:16 PM
  4. Lock Dragging of Cells
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-24-2008, 01:09 PM
  5. Prevent auto format when dragging cells
    By lightecho in forum Excel General
    Replies: 3
    Last Post: 07-14-2007, 02:30 PM
  6. [SOLVED] how to set google search window on side of excel ?
    By Ghosh in forum Excel General
    Replies: 2
    Last Post: 06-24-2006, 02:30 PM
  7. [SOLVED] Deleting "Arrange Side by Side with..." command from Window menuba
    By Peter Rooney in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-05-2005, 11:10 AM

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