I have a spreadsheet that came from an outside source, that has a 1 and 2 in the blue bar to the left of the row #. When you click 1, it shows an expanded view of the spreadsheet, and when you click 2 it shows a contracted version, with some of the rows of information hidden. There is also an icon that shows the range of the rows hidden. I was wondering if anyone knew how to duplicate this. I think it would be helpful as it would allow me to have a view with everything for data entry, but another view with just the essential information to show others. Thanks.
Here a link just to add to Daves answer
http://www.bettersolutions.com/excel...N849613531.htm
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks