+ Reply to Thread
Results 1 to 1 of 1

Unable to Move Objects Off Of Page

  1. #1
    Registered User
    Join Date
    07-23-2008
    Location
    Louisiana, USA
    Posts
    5

    Unable to Move Objects Off Of Page

    I have a workbook that my staff uses to keep track of their time on various projects. Each staff member has a sheet in the workbook. On each sheet is a button labeld "Filter PPE". This button displays a userform on which the staff member can select the Pay Period for which they want to enter time. Each person can select a PPE (Pay Period Ending) date, independent of others.

    On some of the sheets, the user can select any PPE they choose. On a couple of the sheets (the first two), the user can select any PPE except the last one for the year. When the last PPE is selected, the error message "Unable to Move Objects Off Of Page" is displayed. Occassionaly, the message is "Unable to Set the Hidden Property of the Range Class."

    From what I have been able to discern from Google searches and other posts, this problem is often caused by hidden objects on the spreadsheet. One of the sheets has comments all through it. Others have a few comments. I do not understand why it works for all PPEs except the last one. And as far as I can see, there are no other objects on any of the pages except the comments and the FilterPPE button itself.

    Rather than paste a lot of code in the message, I have attached the entire workbook. Thank for your time and assistance.

    (Also, I know about the errors in the "Project - By PPE" tab. Please don't waste your time addressing that issue.)
    Attached Files Attached Files

+ 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. Replies: 3
    Last Post: 11-08-2012, 07:25 PM
  2. unable to move page breaks
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  3. [SOLVED] unable to move page breaks
    By Robin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. [SOLVED] unable to move page breaks
    By Robin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] unable to move page breaks
    By Robin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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