On Open

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
 
F

Frank Kabel

Hi
try the following:
- record a macro while doing these actions manually
- rename this recorded macro to 'Auto_Open()'
 
Top