+ Reply to Thread
Results 1 to 3 of 3

How to hide FREEZE LINES

  1. 07-11-2018, 04:54 AM #1
    AV114
    AV114 is offline
    Registered User
    Join Date
    07-11-2018
    Location
    INDIA
    MS-Off Ver
    16
    Posts
    40

    How to hide FREEZE LINES

    is there any way to hide/change the color freeze pane lines via marco
    Reply With QuoteRegister To Reply
  2. 07-11-2018, 06:32 AM #2
    dominicb
    dominicb is offline
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: How to hide FREEZE LINES

    Good morning AV114

    No.
    But this link may help.

    HTH

    DominicB
    Reply With QuoteRegister To Reply
  3. 07-11-2018, 09:07 AM #3
    Zer0Cool
    Zer0Cool is offline
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: How to hide FREEZE LINES

    The link @dominicb provides is likely the only method for doing what you are asking.

    As far as I know, the freeze panes "line" is not exposed to the VBA object model, aka VBA cannot manipulate it.
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how do I hide freeze pane lines
    By Exel Help Needed in forum Excel General
    Replies: 4
    Last Post: 10-06-2023, 07:50 AM
  2. WRAP text (show last added lines/hide first lines)
    By Jeppe88hansen in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 01-08-2018, 08:58 PM
  3. FREEZE PANE without showing the lines
    By catchnanan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2016, 09:43 AM
  4. Retain freeze panes and border lines varieties when excel file is converted into html.
    By molosser in forum Excel General
    Replies: 0
    Last Post: 08-14-2014, 06:10 PM
  5. Freeze multiple lines and columns
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-18-2014, 06:24 AM
  6. Macro causing Excel to freeze - intended to hide cells with zero value
    By ParkingExcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2012, 02:11 AM
  7. How to hide freeze pane lines?
    By KinSjama in forum Excel General
    Replies: 2
    Last Post: 10-28-2005, 04:14 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1