Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-08-2015, 06:19 AM
NullVBA NullVBA is offline Hide / unhide Rows Windows 7 64bit Hide / unhide Rows Office 2007
Novice
Hide / unhide Rows
 
Join Date: Dec 2015
Posts: 2
NullVBA is on a distinguished road
Default Hide / unhide Rows

Good Afternoon,

i am little bit new to VBA code.

I am working on an excel sheet with different contract Articles, I need to have a code when i double click on the Article heading it hides all its sub Articles, and double click again it unhides them. the problem is i need to repeat this code to all the Articles i have which would be like 100 Article heading. All the codes i find online is fixing the rows to hide like A3:A9 !. i need a criteria to stop the hide maybe until it reaches a blank space.

it is easier for me if i just double click on the Cell that contains the Article name.



Any idea ??? Please help
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide/Unhide Text Based on Drop Down Selection gw1500se Word 3 02-19-2015 12:17 PM
Hide / unhide Rows Hide/Unhide a Block of Text Based on Choice Selection inquirer Word VBA 7 09-22-2014 04:41 PM
Hide / unhide Rows VBA Code Needed that will Hide / Unhide a row when used with a "Check Box" barryoffshore Excel Programming 4 06-23-2014 05:07 AM
Hide/Unhide pictures maloneb PowerPoint 1 01-18-2012 03:34 PM
Hide / unhide Rows Unhide and Re-hide in Excel 2003 thorgal67 Excel 1 07-16-2009 07:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:31 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