How do I stop an Excel sheet from automatically hiding rows when .

G

Guest

When I open an Excel worksheet, several rows of data are automatically
hidden. How can I change this? It's annoying
 
J

JulieD

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically hide/unhide rows 5
Hiding/Unhiding Rows Automatically 1
How do I hide multiple rows under one row IN EXCEL? 2
How to hide infromation in Excel? 3
Overwrite All Cells in Column 2
Hide columns based on row values 2
hiding an image 2
Hiding rows and printing 1

Top