Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet feature help
Hello I am working on a workbook to help prepare project quotes and such. I am using an older workbook created by someone who is no longer with the company as a bit of a template. I have a decent knowledge of Excel and VBA, but there is something in this workbook that I, nor our software gurus, can figure out for the lives of us. In this workbook there are multiple sheets. A few of the sheets have repeating blocks of formatted data. In this case the repeated blocks are for robot cells that are represented by the exact same information, but can contain different data (e.g. differing man-hours in different engineering disciplines, etc). A user can add (robot) cells as needed for a project with a simple macro. Easy enough. The thing I really do not get is the method used to hide/unhide the ranges. One of the requests is that the user can hide/unhide the individual (robot) cells. Again done easily enough with a little VBA. However, the users want it to be done like the old workbook that we are updating. In this book there are controls (?) added within the workbook instance but outside the row and column headings. Basically the button controls to hide/unhide the ranges are in their own grey area around the worksheet. When the data is hidden the buttons are little black plus signs that can be clicked to expand the hidden data, in this case the robot cell info. When the data is expanded (unhidden) the button displays a minus sign and there is a black line in the grey area along the range that was unhidden. Clicking either the button or on this line will again hide the range. There are also little one’s and two’s extended beyond where the row and column headings intersect, one set of numbers for the rows and another for the columns. Clicking the one hides all the ranges and the twos will expand them all again. As I said before, I have no idea where these things come from or how they are created. I have dug through all the VBA associated with the workbook and can't find any code that would seem to have anything at all to with these nifty buttons. As you guys can tell by now, I really don't even know what to call them so my internet scouring has proven futile. I feel that I am missing some easy click and implement functionality in Excel that I have forgotten about from a class years ago or something. I very much appreciate any light that anyone can shed on my little mystery. Thank you in advance. -- Josh22 ------------------------------------------------------------------------ Josh22's Profile: http://www.excelforum.com/member.php...o&userid=24080 View this thread: http://www.excelforum.com/showthread...hreadid=377115 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I rename an Excel worksheet when the feature is grap out? | Excel Worksheet Functions | |||
Create a search feature in a worksheet | Links and Linking in Excel | |||
Tab feature no longer working on worksheet | Excel Worksheet Functions | |||
Worksheet feature help | Excel Programming | |||
Worksheet feature help | Excel Programming |