+ Reply to Thread
Results 1 to 3 of 3

Page Setup ends in error

  1. #1
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Page Setup ends in error

    Hi all

    The below code works for all users, except for one for whom it ends in error "Run-time error '1004': Unable to get the RightFooter property of the PageSetup class"

    Please Login or Register  to view this content.
    The same happens for some other settings that need changing too (such as LeftMargin etc.)

    According to Microsoft help page this happens when no printes are installed. However, the user has them defined and can also print.

    What other reasons could there be?

    Thank you for your help
    FD

  2. #2
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Re: Page Setup ends in error

    Hi everyone

    I allow myself to bump this one.
    I can't think of a reason why this should not work when the printer is defined properly.

    Thanks
    FD

  3. #3
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Re: Page Setup ends in error

    Good day all

    I'm gonna try this one more time
    Would anyone have an idea or an input what the cause could be?

    Thanks
    FD

+ 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] VB code to do page setup and find page breaks
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2019, 06:37 PM
  2. [SOLVED] how to insert modified page setup in print setup
    By JEAN1972 in forum Excel General
    Replies: 1
    Last Post: 01-11-2019, 06:02 AM
  3. [SOLVED] Unknown Error in Page Setup
    By CLSSY56 in forum Excel General
    Replies: 3
    Last Post: 06-08-2016, 01:54 PM
  4. [SOLVED] need help with page setup/print Setup on a worksheet
    By laurabach in forum Excel General
    Replies: 9
    Last Post: 04-28-2013, 11:44 PM
  5. Macro error : Method 'print area' of object 'page setup' failed.
    By aka189 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-25-2012, 10:54 AM
  6. Excel > page setup > Sheet > Print > Cells Error As...
    By tikchye_oldLearner57 in forum Excel General
    Replies: 2
    Last Post: 05-16-2006, 11:35 AM
  7. Error on ExecuteExcel4Macro Page.Setup
    By Claus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2005, 01: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