Results 1 to 4 of 4

Thread: Maximizing

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 2006
    Posts
    62

    Maximizing

    I took a sheet I worte in excel and saved as a web page with interactability. the result is a cropped sheet and not exactly what I was looking for.

    Can someone advise me on how have the resultant sheet maximize itself to take use of the full screen?

    "If at first you don't succeed, destroy all evidence you ever tried."
    http://www.ussretribution.com

  2. #2
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: Maximizing

    not sure if ths will do exactly what you want
    VB Code:
    1. ActiveWindow.WindowState = xlMaximized

    pete

  3. #3
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Maximizing

    the result is a cropped sheet and not exactly what I was looking for.
    Are you looking for the web browser to be maximized or and instance of Excel?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  4. #4
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Maximizing

    I take it you mean that the excel 'interactive' on the web page is cropped area?
    I think if you are using plugin/embedded stuff on pages you can specify height and width, probably its in there.
    otherwise I have no idea - having never tried something like that. Hope you find the answer.

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

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



Click Here to Expand Forum to Full Width