Is it possible to automatically run a macro upon a spreadsheet
 

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

Is it possible to automatically run a macro upon a spreadsheet
 

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

--
jmoffa
-----------------------------------------------------------------------
jmoffat's Profile: http://www.excelforum.com/member.php...nfo&userid=115
View this thread: http://www.excelforum.com/showthread.php?threadid=26375

Is it possible to automatically run a macro upon a spreadsheet
 

Thank you
-----Original Message-----

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.


--
jmoffat
----------------------------------------------------------
--------------
jmoffat's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=1151
View this thread:
http://www.excelforum.com/showthread...hreadid=263758

.

Is it possible to automatically run a macro upon a spreadsheet
 

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

--
Regards,
Tom Ogilvy

"Steve" wrote in message
...
Thank you
-----Original Message-----

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.


--
jmoffat
----------------------------------------------------------
--------------
jmoffat's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=1151
View this thread:
http://www.excelforum.com/showthread...hreadid=263758

.