How do I stop an Excel sheet from automatically hiding rows when .
When I open an Excel worksheet, several rows of data are automatically
hidden. How can I change this? It's annoying |
Hi
I'm guessing there's some code running that's doing this. After you've opened your workbook, right mouse click on a sheet tab, and choose view code. On the left hand side of the VBE window (under where you see your workbook's name in bold) you'll see ThisWorkbook - double click on it and some code should come up on the right ... i'm guessing your problem is in there. Cheers JulieD "kazyreed" wrote in message ... When I open an Excel worksheet, several rows of data are automatically hidden. How can I change this? It's annoying |
All times are GMT +1. The time now is 02:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com