Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-26-2019, 03:52 PM
Lambo Lambo is offline Expand/Hide Subordinates with double click Windows 7 32bit Expand/Hide Subordinates with double click Office 2010
Novice
Expand/Hide Subordinates with double click
 
Join Date: Mar 2019
Posts: 2
Lambo is on a distinguished road
Default Expand/Hide Subordinates with double click

Hi,

I'm trying to create an organisation chart where the subordinates are expanded or hidden by double clicking on the manager.

At the moment, I use this macro using the "Behaviour" option on double click:

Sub Expand()
Call Visio.Application.Addons("OrgC11").Run("/expandsubordinates")


End Sub

But ideally I'd like double click to be "hide/expand subordinates", swapping them to the opposite state they're initially in.

Anyone able to help with this? As you can probably tell, I've no experience with VBA, Macros or even Visio until this week!

Thanks
Reply With Quote
 

Tags
vba visio macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
Expand/Hide Subordinates with double click Double click on a cell to add check mark? robbinskelly7 Excel 1 02-09-2015 07:05 PM
Expand/Hide Subordinates with double click Excel Files Won't Open With Double Click ykhalil Office 1 11-10-2014 05:00 AM
Play Shockwave on a double click dedine PowerPoint 4 06-03-2013 08:26 AM
Expand/Hide Subordinates with double click Drop-Down Menu, show-hide, expand-collapse??? 300zxmuro Word 1 02-27-2011 03:02 PM
Cannot Double Click on Microsoft Word Document weeleong87 Word 0 07-19-2009 05:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft