| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move this rectangle to hide the unused cells
Xl2000
I have 90 rows with formulas that are not being used yet and I don't want to see them untill I need them. Each work day that is monday through friday I will use the next 2 rows. So what I created a Rectangle colored white to hide the unused cells and I have a macro that I click on to move the Rectangle 2 rows Question Is it possible to have XL move this rectangle each work day when I open this sheet and not move it on the weekends when I may want to review the sheet Sub Rectangle10_Click() ActiveSheet.Shapes("Rectangle 9").Select Selection.ShapeRange.IncrementTop 24.75 End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide unused rows and columns | Excel Discussion (Misc queries) | |||
| Hide unused rows based on column info | Excel Worksheet Functions | |||
| How do you hide unused cells in a spreadsheet? | Excel Discussion (Misc queries) | |||
| MOVE DATA INTO UNUSED ROWS | Excel Worksheet Functions | |||
| How to hide unused cells when running accumulated totals | Excel Worksheet Functions | |||
Threaded Mode
