On Open

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

Can anyone help me out with this?

I want a worksheet to preform these actions each time it
opens:

Automatically unhide any hidded rows (especially those
hidden by the auto-filter feature).
Then sort the entire worksheet based on one column
(contents of the column).


Thanks.

-Ian
 
Hi
try the following:
- record a macro while doing these actions manually
- rename this recorded macro to 'Auto_Open()'
 
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

HIDDEN ROWS 6
Help with conditionally unhiding columns 1
rows won't unhide 5
Hidden rows unhide themselves when formulas are written 3
Macro that will unhide then hide rows 10
Numbering rows with filters 1
Date Range Changing Each Time Worksheet Is Opened 2
Filter based on list 1

Back
Top