Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
opening a worksheet at a specific point
i have a diary , i would like it to open at the specific date every time i
openen the file.PLEASE HELP |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
opening a worksheet at a specific point
Hi crusty53
Do you have column where you enter the date each day ? -- Regards Ron de Bruin http://www.rondebruin.nl "crusty53" wrote in message ... i have a diary , i would like it to open at the specific date every time i openen the file.PLEASE HELP |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
opening a worksheet at a specific point
Yes it has a column were the date is entered every day.
"Ron de Bruin" wrote: Hi crusty53 Do you have column where you enter the date each day ? -- Regards Ron de Bruin http://www.rondebruin.nl "crusty53" wrote in message ... i have a diary , i would like it to open at the specific date every time i openen the file.PLEASE HELP |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
opening a worksheet at a specific point
Hi Hi crusty53
You can try this find todays date in column A in "Sheet1" Sub Find_Todays_Date() Dim FindString As Date Dim rng As Range FindString = Date With Sheets("Sheet1").Range("A:A") Set rng = .Find(What:=FindString, _ After:=.Cells(.Cells.Count), _ LookIn:=xlFormulas, _ LookAt:=xlWhole, _ SearchOrder:=xlByRows, _ SearchDirection:=xlNext, _ MatchCase:=False) If Not rng Is Nothing Then Application.Goto rng, True Else MsgBox "Nothing found" End If End With End Sub You van run the macro in the workbook open event in the thisworkbook module -- Regards Ron de Bruin http://www.rondebruin.nl "crusty53" wrote in message ... Yes it has a column were the date is entered every day. "Ron de Bruin" wrote: Hi crusty53 Do you have column where you enter the date each day ? -- Regards Ron de Bruin http://www.rondebruin.nl "crusty53" wrote in message ... i have a diary , i would like it to open at the specific date every time i openen the file.PLEASE HELP |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
opening a worksheet at a specific point
Ron, thanks,but this is a bit too advanced for me.But if you have time i
would like to explore it further.Please a bit more of an explanation as to what your reply means and how i go about performing what you told me.Your humble beginner crusty. "crusty53" wrote: Yes it has a column were the date is entered every day. "Ron de Bruin" wrote: Hi crusty53 Do you have column where you enter the date each day ? -- Regards Ron de Bruin http://www.rondebruin.nl "crusty53" wrote in message ... i have a diary , i would like it to open at the specific date every time i openen the file.PLEASE HELP |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
opening a worksheet at a specific point
Hi
Copy the macro in a normal module 1. Alt-F11 2. InsertModule from the Menubar 3. Paste the Code there 4. Alt-Q to go back to Excel 5. Alt-F8 to run the subs Note :My Sheet is names "Sheet1" Test the macro first and I help you to run it automatic -- Regards Ron de Bruin http://www.rondebruin.nl "crusty53" wrote in message ... Ron, thanks,but this is a bit too advanced for me.But if you have time i would like to explore it further.Please a bit more of an explanation as to what your reply means and how i go about performing what you told me.Your humble beginner crusty. "crusty53" wrote: Yes it has a column were the date is entered every day. "Ron de Bruin" wrote: Hi crusty53 Do you have column where you enter the date each day ? -- Regards Ron de Bruin http://www.rondebruin.nl "crusty53" wrote in message ... i have a diary , i would like it to open at the specific date every time i openen the file.PLEASE HELP |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
opening a worksheet at a specific point
Hi Ron, Did as directed ,i get a run time error at 9,i think my sheet is
named"Diary" and the colunm is "B:B" "Ron de Bruin" wrote: Hi Copy the macro in a normal module 1. Alt-F11 2. InsertModule from the Menubar 3. Paste the Code there 4. Alt-Q to go back to Excel 5. Alt-F8 to run the subs Note :My Sheet is names "Sheet1" Test the macro first and I help you to run it automatic -- Regards Ron de Bruin http://www.rondebruin.nl "crusty53" wrote in message ... Ron, thanks,but this is a bit too advanced for me.But if you have time i would like to explore it further.Please a bit more of an explanation as to what your reply means and how i go about performing what you told me.Your humble beginner crusty. "crusty53" wrote: Yes it has a column were the date is entered every day. "Ron de Bruin" wrote: Hi crusty53 Do you have column where you enter the date each day ? -- Regards Ron de Bruin http://www.rondebruin.nl "crusty53" wrote in message ... i have a diary , i would like it to open at the specific date every time i openen the file.PLEASE HELP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Invalid Web Query" error on opening a 2003 worksheet | Excel Discussion (Misc queries) | |||
Event macro that targets specific worksheet | Excel Discussion (Misc queries) | |||
Open Excel App without a blank worksheet opening | Excel Discussion (Misc queries) | |||
Can specific cells on a worksheet be hidden & password protected? | Excel Worksheet Functions | |||
Hyperlink to specific worksheet in Excel | Links and Linking in Excel |