Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go to worksheet upon opening
Is there a way to have the same worksheet pop up every time the excel file is
opened...... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go to worksheet upon opening
hi
yes. Private Sub Workbook_Open() Sheets("Sheet1").Activate Range("A1").Select End Sub adjust the sheet name and range to suit this is workbook code. press ALT+F11. this will bring up the vb editor. at the far right, expand your project(file). double click ThisWorkbook. in the code window(far right), click the right drop down and select Workbook. the workbook open event should default in (see above). paste the two line between workbook open and end sub above between workbook open and end sub in your vb editor. close the vb window and save the file. next time you open the file the file, excel will goto the sheet and range you specify. Regards FSt1 "SageOne" wrote: Is there a way to have the same worksheet pop up every time the excel file is opened...... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening worksheet | Excel Discussion (Misc queries) | |||
Opening Worksheet | Excel Discussion (Misc queries) | |||
Opening a worksheet | Excel Discussion (Misc queries) | |||
VBA Opening worksheet, name changes | Excel Discussion (Misc queries) | |||
OPening worksheet | Excel Programming |