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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
move this rectangle to hide the unused cells
Why not just design the formulas so the cells look blank when there is no
entry in a specified cell in the row in B30 as an example =if(A30="","",currentformula) So when I enter something in column A of that row (row 30), then the formula calculates as designed, otherwise, the cell looks blank. Regards, Tom Ogilvy ~Alan Rosenberg Miami wrote in message ... 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 |
Reply |
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 |