+ Reply to Thread
Results 1 to 2 of 2

Inactive TreeView component after opening file

  1. #1
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Inactive TreeView component after opening file

    Hi,
    I'm using TreeView components on a sheet for Drag&Drop, each component shows path to the file (after file is Drag-Dropped in it).
    But there is one issue - just after file is opened those TreeViews are not "active" and can't be used.
    I found workaround: scroll sheet after file is opened, like this
    Please Login or Register  to view this content.
    Without this code I need to make some manual scrolling/activation on a sheet to make TreeView controls active.
    Is there some better way to get my controls be ready to work just after file is opened?
    I've commented scrolling code in attached workbook - to demostrate how it's working without it.
    Any suggestions?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Inactive TreeView component after opening file

    Nobody have no ideas? :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Changing Treeview Icon based on File Extension
    By rampal in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-23-2021, 08:35 PM
  2. [SOLVED] Transfer ALL nodes from a UserForm TreeView into a TreeView on a worksheet with VBA
    By Jerbinator in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2015, 07:52 AM
  3. Opening file message when opening a file from an http address
    By The_Real_MerlinXL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2010, 12:33 PM
  4. Save Treeview control into File
    By malepati in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2010, 01:54 AM
  5. close inactive file
    By jseufert in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2009, 03:03 PM
  6. Replies: 0
    Last Post: 05-26-2006, 07:45 AM
  7. [SOLVED] add automatically a component to component palette
    By Maileen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2006, 12:10 PM

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