+ Reply to Thread
Results 1 to 4 of 4

VBA question.. full screen

  1. #1
    Forum Contributor
    Join Date
    06-18-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    106

    VBA question.. full screen

    Hi Guys,

    I have an issue with this code below, I'm getting a runtime error. Also the heading are still present upon opening despite being in fullscreen mode.

    Any ideas?

    Many Thanks in advance!

    Please Login or Register  to view this content.
    Thanks.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,936

    Re: VBA question.. full screen

    Have you entered Debug mode when the error occurs? If so, what line of code is causing the error? What is the error message?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: VBA question.. full screen

    hi niceguy21, there are two issues:

    1.
    Please Login or Register  to view this content.
    - DisplayHeadings is not a property of the Application object
    2. chgflag variable - unless set as public it's redundant and does nothing

  4. #4
    Forum Contributor
    Join Date
    06-18-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    106

    Re: VBA question.. full screen

    Quote Originally Posted by watersev View Post
    hi niceguy21, there are two issues:

    1.
    Please Login or Register  to view this content.
    - DisplayHeadings is not a property of the Application object
    2. chgflag variable - unless set as public it's redundant and does nothing

    Thanks for this

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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