Hidden rows automatically unhide when I open Excel Spreadsheet.
How do I prevent hidden lines from "unhiding" when I open the spreadsheet.
|
Hidden rows automatically unhide when I open Excel Spreadsheet.
When excel opens, it won't unhide anything--everything is kept the way it was
when it was last saved. But if you have a macro that runs when the workbook opens, all bets are off. So if some rows that were hidden when the workbook was last saved are now visible, I'd look for a helpful macro. Rick wrote: How do I prevent hidden lines from "unhiding" when I open the spreadsheet. -- Dave Peterson |
All times are GMT +1. The time now is 06:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com