Results 1 to 8 of 8

Thread: The Return of "Lochinvar" - Resolved

  1. Sep 21st, 2004, 03:30 AM #1
    RadarListener
    RadarListener is offline

    Thread Starter
    New Member
    Join Date
    Sep 2004
    Location
    South Australia
    Posts
    12

    Resolved The Return of "Lochinvar" - Resolved

    Resolved. Thanks to all who helped.
    Last edited by RadarListener; Oct 12th, 2004 at 12:38 AM.
    Reply With Quote Reply With Quote
  2. Sep 21st, 2004, 08:48 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    Hiding the menu bar.
    Check out the commandbars - reference the office 8 or 9 in vba code to access.

    Black outline... dunno - property of the sheet perhaps?


    Vince

    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...
    Reply With Quote Reply With Quote
  3. Sep 21st, 2004, 06:12 PM #3
    RadarListener
    RadarListener is offline

    Thread Starter
    New Member
    Join Date
    Sep 2004
    Location
    South Australia
    Posts
    12
    Application.ActiveSheets.AnnoyingBlackOutline.Visible = False?

    Reply With Quote Reply With Quote
  4. Sep 22nd, 2004, 07:42 PM #4
    RadarListener
    RadarListener is offline

    Thread Starter
    New Member
    Join Date
    Sep 2004
    Location
    South Australia
    Posts
    12
    I still don't know what to do. Can anybody help me?
    Reply With Quote Reply With Quote
  6. Sep 23rd, 2004, 10:23 AM #5
    DavW
    DavW is offline
    Member
    Join Date
    Mar 2002
    Location
    Grimsby (up the Mariners!)
    Posts
    45

    Question Worth a shot

    The only way I know of hiding the outline is to protect the worksheet but cells can't be selected by the user. This may or may not be a problem to you.

    Maybe try the excel newsgroup at M$ for an alternative?
    Reply With Quote Reply With Quote
  7. Sep 23rd, 2004, 10:58 AM #6
    NeedSomeAnswers
    NeedSomeAnswers is offline
    Superbly Moderated NeedSomeAnswers's Avatar
    Join Date
    Jun 2002
    Location
    Manchester uk
    Posts
    2,657
    Don't know how to get rid of the outline, but the follwing code will get rid of the - "lil box in the bottom right hand corner that allows you to repeat the formula"

    VB Code:
    1. Application.CellDragAndDrop = False
    Reply With Quote Reply With Quote
  8. Oct 11th, 2004, 09:36 PM #7
    RadarListener
    RadarListener is offline

    Thread Starter
    New Member
    Join Date
    Sep 2004
    Location
    South Australia
    Posts
    12
    Thanks for all your help everyone. I have now finished the assignment with credit, possibly distinction. Much appreciated.
    Reply With Quote Reply With Quote
  9. Oct 11th, 2004, 11:15 PM #8
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709
    Dont forget to edit your original post with Resolved (or the
    green checkmark) if this issue is solved.

    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 Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API 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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width