ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Start up (https://www.excelbanter.com/excel-discussion-misc-queries/39007-start-up.html)

Lee

Start up
 
How to set up in Excel where everytime when I open the file, the first
worksheet will always be displayed regardless of how I save it before?

Thanks!

Dave Peterson

You'll need to use a macro:

Option Explicit
sub auto_open()
worksheets(1).select
end sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Lee wrote:

How to set up in Excel where everytime when I open the file, the first
worksheet will always be displayed regardless of how I save it before?

Thanks!


--

Dave Peterson


All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com