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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

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
Overwrite All Cells in Column 2
How do I hide multiple rows under one row IN EXCEL? 2
Hiding/Unhiding Rows Automatically 1
hiding an image 2
How to hide infromation in Excel? 3
Hide columns based on row values 2
Excel Unlink open excel files 2

Back
Top