| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I open Excel I want it to open on Sheet 1
It Works!
Thanks to All, You guys are awesome! "Michael M" wrote: Gord Thanks for the heads up. Just when I thought I was getting smarter !! Regards Michael M "Gord Dibben" wrote: Michael Info only........... The "This workbook contains macros" message appears long before any code runs. It appears when you first open the workbook and Excel notices the file contains macros or even an empty module. No way to turn that mesage off unless you change security to "Low" which is not a good idea, or digitally sign the workbook. Gord Dibben MS Excel MVP On Tue, 23 Jan 2007 13:51:01 -0800, Michael M wrote: Hi George You can add the line Application.DisplayAlerts=False to disable the macro message from appearing Regards Michael M "George Nicholson" wrote: Add this to the "ThisWorkbook" module: (Alt-F11 to open VB editor expand Project & ExcelObjects dblClick ThisWorkbook entry copy & paste in code window. Save.) Private Sub Workbook_Open() ThisWorkbook.Worksheets("Sheet1").Activate End Sub Change "Sheet1" to the name of your cover page as the User sees it. Note: you now have code in your workbook. Users can choose not to enable macros, so it isn't foolproof, but I'm not aware of any way to do what you want that wouldn't envolve coding. HTH, "traveye" wrote in message ... OK, I have an excel file that many employees use and save thier information in. If an employees enters info into sheet 4 and then saves it, when the next employee opens the same file it will open directly to sheet 4. This file has a "cover page" which is sheet 1. I always want excel to open up to sheet 1 no matter what sheet it was previously saved in. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get Excel to open email for single sheet? | Excel Worksheet Functions | |||
| open new microsoft excel sheet and found my last same file all ti. | Excel Worksheet Functions | |||
| Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
| Click on Excel Doc Starts Excel but Excel does not Open the Doc. | Excel Discussion (Misc queries) | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Hybrid Mode
