Is it possible to automatically run a macro upon a spreadsheet

[Steve]

I would like to save a macro with a specific spreadsheet.

Upon opening that spreadsheet, I would like some
formatting changes to occur automatically (without me
having to manually run the macro):

i)Highlight all text and change the zoom percentage to 75%
ii) Autofit columns (but exclude row 1 when deciding how
big to make the columns).

Thanks in advance

 

[jmoffat]

try using auto_open


such as:


sub auto_open

sheet("my sheet).select
range("a1:a50").select
etc....

end sub


This will run everytime the workbook is opened

 

[Steve]

Thank you

 

[Tom Ogilvy]

You can't autofit a column ignoring row1 unless you delete all the entries
in row1, do the autofit, then put the entries back.