Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
on open, always display sheet1
Hi
is it possible to always force a particular worksheet to be the visible active one every time the spreadsheet is opened? So for example if I have sheet1 and sheet2, and save the spreadsheet while in sheet2, the next time I open the spreadhseet, I want to force sheet1 to be the visible sheet. is there some sort of 'on-open' function I could use with a macro that directs to sheet1? thanks for any help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
on open, always display sheet1
Try this macro:
Sub Auto_open() Sheets(1).select cells(1,1).select 'If you want it to go to the A1 cell End Sub Cheers, AP "confused" wrote in message ... Hi is it possible to always force a particular worksheet to be the visible active one every time the spreadsheet is opened? So for example if I have sheet1 and sheet2, and save the spreadsheet while in sheet2, the next time I open the spreadhseet, I want to force sheet1 to be the visible sheet. is there some sort of 'on-open' function I could use with a macro that directs to sheet1? thanks for any help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
on open, always display sheet1
Hi
In Excel, go to Tools, Macro, Visual Basic Editor. Double click ThisWorkbook for your excel file. If you cannot see the excel file name, go to View, Project Explorer. In the drop down at the top which says (General) choose the Workbook option. You will be given this empty macro: Private Sub Workbook_Open() End Sub which is the macro you hope exists! Inside this put worksheets("MyworksheetName").Activate where you have already called one of your sheets "MyworksheetName". regards Paul PS if you are distributing this workbook, users may get a security warning. Tell them to go to Tools, Macro, Security. Set the protection to Medium in Security Level and in the Trusted Publishers section they need to "Trust access to visual basic project". Save the file, close it and reopen. confused wrote: Hi is it possible to always force a particular worksheet to be the visible active one every time the spreadsheet is opened? So for example if I have sheet1 and sheet2, and save the spreadsheet while in sheet2, the next time I open the spreadhseet, I want to force sheet1 to be the visible sheet. is there some sort of 'on-open' function I could use with a macro that directs to sheet1? thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display a value from Sheet1-A1:A10 in Sheet2-B1 | Excel Worksheet Functions | |||
Display Rows From Sheet1 In Sheet2 (Import) | Excel Worksheet Functions | |||
Combine 3 Columns on Sheet2 to Display in 1 Column on Sheet1 | Excel Worksheet Functions | |||
Open sheet1 always! | Excel Programming | |||
How? Force Sheet1 to display each time the workbook is opened. | Excel Programming |