Reply to thread

Message: [QUOTE="JE McGimpsey, post: 6792909"] No, it's not possible to delete unused rows or columns with any version of Windows XL. It may be possible with another application. An XL97-2004 worksheet has 256 columns and 65536 rows. Always. You can limit the scroll area by running something like this event macro each time the workbook opens (type or paste it in the ThisWorkbook module - CTRL/right-click the workbook title bar and choose View Code): Private Sub Workbook_Open() Worksheets("Sheet1").ScrollArea = "A1:J10" End Sub This prevents scrolling or selecting a cell outside the scroll area with the mouse, or the arrow, Return, or tab keys. If you hide the columns/rows outside the scroll area, it will look like the surplus columns/rows were deleted However, it doesn't prevent the user from entering a cell address in the name box (on the left side of the formula bar), hitting enter, and selecting a cell that way. Nor does it prevent references to cells that are hidden. [/QUOTE]