LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick B
 
Posts: n/a
Default Open Automatically on a particular Worksheet

You could open the Workbook and go to Tools-Options-Visual Basic Editor,
then in the Project Explorer pane on the left side of the screen,
double-click on ThisWorkbook and then paste in the following code:
Private Sub Workbook_Open()
Sheets(1).Select
End Sub
Of course, everyone would have to either set Macro Security on their
computers (Tools-Macro-Security) to Medium and select to Enable the macros
when the workbook opens, or set it to Low (not recommended).

"Fedarni" wrote:

I have a spredsheet that is updated by many. How can I make it so that
spreadsheet, no matter which worksheet the last person saved in, always opens
on the first worksheet.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing unopened worksheet into an open Workbook GrayesGhost Excel Discussion (Misc queries) 24 July 3rd 08 10:06 PM
Master worksheet automatically enters data into sub worksheets Ken Excel Discussion (Misc queries) 1 November 1st 05 10:36 PM
automatically copy data from one worksheet to another LC Excel Worksheet Functions 1 July 23rd 05 03:36 AM
How do I open a specific worksheet using windows exp... vertblancrouge Excel Discussion (Misc queries) 4 April 19th 05 08:55 PM
How do I get my personal macro worksheet to open whenever I open . Claudia_R Excel Discussion (Misc queries) 3 December 9th 04 11:59 PM


All times are GMT +1. The time now is 02:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"