Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically generating spreadsheet B from spreadsheet A | Excel Discussion (Misc queries) | |||
Automatically update spreadsheet from another spreadsheet | Excel Worksheet Functions | |||
Updating a spreadsheet automatically | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
How to run a macro automatically when i open my excel spreadsheet | Excel Programming |