J
Josh22
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.
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.