Consulting

Results 1 to 5 of 5

Thread: Sheet PrintOut Halt

  1. #1
    VBAX Newbie
    Joined
    Mar 2008
    Posts
    2
    Location

    Sheet PrintOut Halt

    Hi

    I don't understand why a printing is halted when
    PrintOut method is called for Sheet Object like this:

    Sheet.Application.ScreenUpdating = True
    Sheet.Select
    Sheet.PrintOut

    Nick

  2. #2
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    Howdy, and welcome to the board.

    Is this specific to a Mac version of Excel? If so, which version?

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

  3. #3
    VBAX Newbie
    Joined
    Mar 2008
    Posts
    2
    Location
    No, I use MS Excel 2003, and I have halting problem with printing sheets of one excel file, but for many other files they are printed ok

  4. #4
    VBAX Mentor tpoynton's Avatar
    Joined
    Feb 2005
    Location
    Clinton, MA
    Posts
    399
    Location
    this is the mac forum for mac-specific questions! you'd be better off posting in the Excel help forum.

    no need to qualify application.screenupdating with sheet; try removing that, although it doesnt sound like it will help.

  5. #5
    Mac Moderator VBAX Expert shades's Avatar
    Joined
    May 2004
    Location
    Kansas City, USA
    Posts
    638
    Location
    I have moved this thread to Excel Help, since it is not Mac specific.

    Software: LibreOffice 3.3 on Mac OS X 10.6.5
    (retired Excel 2003 user, 3.28.2008 )
    Humanware: Older than dirt
    --------------------
    old, slow, and confused
    but at least I'm inconsistent!

    Rich

Posting Permissions

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