Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When opening a workbook, need to ensure user opens in a certain ce
When opening the workbook, I want the next person to open in a particular
cell in a certain sheet. Not where the last person saved the workbook. I need to do something on the opening of the workbook, but cannot think. Please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
When opening a workbook, need to ensure user opens in a certain ce
Try this
Private Sub Workbook_Open() Worksheets("Sheet1").Select '<-----Edit as required Cells(1, 1).Select '<-----Edit as required End Sub Mike "Gover" wrote: When opening the workbook, I want the next person to open in a particular cell in a certain sheet. Not where the last person saved the workbook. I need to do something on the opening of the workbook, but cannot think. Please help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
When opening a workbook, need to ensure user opens in a certai
hmm, sorry but I've tried this but have no idea. Went into the View Code on
the tab. copied your bit. Lets say I want them to go to sheet 1 cell a1. How would I change what you've written. "Mike" wrote: Try this Private Sub Workbook_Open() Worksheets("Sheet1").Select '<-----Edit as required Cells(1, 1).Select '<-----Edit as required End Sub Mike "Gover" wrote: When opening the workbook, I want the next person to open in a particular cell in a certain sheet. Not where the last person saved the workbook. I need to do something on the opening of the workbook, but cannot think. Please help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
When opening a workbook, need to ensure user opens in a certai
Ok,
With your workbook open hit ALT+F11 to open the VB editor. Double click 'This Workbook' on the left side. On the righthand side there are 2 dropdowns. In the left one select 'workbook' In the right one select open. Paste this in between the Sub() End sub Worksheets("Sheet1").Select '<-----Edit as required Cells(1, 1).Select '<-----Edit as required Click File Close and return to close the VB editor and don't forget to save. The code will then execute whenever the workbook is opened. Mike "Gover" wrote: hmm, sorry but I've tried this but have no idea. Went into the View Code on the tab. copied your bit. Lets say I want them to go to sheet 1 cell a1. How would I change what you've written. "Mike" wrote: Try this Private Sub Workbook_Open() Worksheets("Sheet1").Select '<-----Edit as required Cells(1, 1).Select '<-----Edit as required End Sub Mike "Gover" wrote: When opening the workbook, I want the next person to open in a particular cell in a certain sheet. Not where the last person saved the workbook. I need to do something on the opening of the workbook, but cannot think. Please help |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
When opening a workbook, need to ensure user opens in a certai
Excellent - it works
thanks alot "Mike" wrote: Ok, With your workbook open hit ALT+F11 to open the VB editor. Double click 'This Workbook' on the left side. On the righthand side there are 2 dropdowns. In the left one select 'workbook' In the right one select open. Paste this in between the Sub() End sub Worksheets("Sheet1").Select '<-----Edit as required Cells(1, 1).Select '<-----Edit as required Click File Close and return to close the VB editor and don't forget to save. The code will then execute whenever the workbook is opened. Mike "Gover" wrote: hmm, sorry but I've tried this but have no idea. Went into the View Code on the tab. copied your bit. Lets say I want them to go to sheet 1 cell a1. How would I change what you've written. "Mike" wrote: Try this Private Sub Workbook_Open() Worksheets("Sheet1").Select '<-----Edit as required Cells(1, 1).Select '<-----Edit as required End Sub Mike "Gover" wrote: When opening the workbook, I want the next person to open in a particular cell in a certain sheet. Not where the last person saved the workbook. I need to do something on the opening of the workbook, but cannot think. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user cannot access his share workbook after opening network path. | Excel Discussion (Misc queries) | |||
How do I insert a message when a user opens my Excel workbook? | Excel Discussion (Misc queries) | |||
Opening workbook in user-defined folder | Excel Worksheet Functions | |||
Personal workbook opens when Excel opens | Excel Discussion (Misc queries) | |||
When opening an existing workbook, Excel opens but not the workbo. | Excel Discussion (Misc queries) |