 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008How to point to a spreadsheet at startup
Hi, I created an index sheet and I would like to point at it when starting up the file. Can it be done on off07? TIA Mike Let's say that in a given workbook there exists a shhet that should always be activated when the file is opened. In the workbook code area, include the following macro: Private Sub Workbook_Open() Sheets("index").Activate End Sub  SignatureGary''s Student - gsnu200776 > Hi, > I created an index sheet and I would like to point at it when starting up > the file. > Can it be done on off07? > TIA > Mike Thanks Gary. I tried it but when I open the file, Excel still points to the last viewed sheet instead of Index. Mike > Let's say that in a given workbook there exists a shhet that should always > be [quoted text clipped - 11 lines] >> TIA >> Mike Let’s make sure it's in the correct place. Because it is workbook code, it is very easy to install and use: 0. remove the version installed originally 1. right-click the tiny Excel icon just to the left of File on the Menu Bar 2. select View Code - this brings up a VBE window 3. paste the stuff in and close the VBE window If you save the workbook, the macro will be saved with it. To remove the macro: 1. bring up the VBE windows as above 2. clear the code out 3. close the VBE window To learn more about macros in general, see: http://www.mvps.org/dmcritchie/excel/getstarted.htm To learn more about Event Macros (worksheet code), see: http://www.mvps.org/dmcritchie/excel/event.htm SignatureGary''s Student - gsnu200776 > Thanks Gary. > I tried it but when I open the file, Excel still points to the last viewed [quoted text clipped - 16 lines] > >> TIA > >> Mike Gary, I'm sure your code works, but for some reasons, Excel would not see it at startup. I'm using Excel 2007 > Let’s make sure it's in the correct place. > [quoted text clipped - 46 lines] >> >> TIA >> >> Mike What level of Macro Security are you running? If High, the macros are disabled without warning. Gord Dibben MS Excel MVP >Gary, >I'm sure your code works, but for some reasons, Excel would not see it at [quoted text clipped - 51 lines] >>> >> TIA >>> >> Mike
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.