Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel/visual basic
1. I have a workbook with several worksheets, and would
like to creat a back button so that when I am looking at my diagram wooksheet I am able to return to the previous worksheet. I am not sure what the code would be enable to do this, do you? 2. I would like to some how keep updated records on how particular items are performing on a daily basis, is there a way to flag a cell that has been updated on that particulare day and keep track of the info in an inconspicuas way so it is not shown on the main worksheet. I hope my questions make sence and someone can help me with them.............. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel/visual basic
Activesheet.previous.Select
Perhaps using the workbook level SheetChange event. (if changes are made by users). If you share the workbook under the Tools menu, Excel will build a history for you. See help for details. -- Regards, Tom Ogilvy "Mara" wrote in message ... 1. I have a workbook with several worksheets, and would like to creat a back button so that when I am looking at my diagram wooksheet I am able to return to the previous worksheet. I am not sure what the code would be enable to do this, do you? 2. I would like to some how keep updated records on how particular items are performing on a daily basis, is there a way to flag a cell that has been updated on that particulare day and keep track of the info in an inconspicuas way so it is not shown on the main worksheet. I hope my questions make sence and someone can help me with them.............. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel/visual basic
That code (Activesheet.previous.Select) will take me one worksheet ahead not to the previous worksheet I was on "last worksheet". Can you help me with that? Ex: I have links on worksheet1 that will direct me to diagrams in worksheet 6 but want the command button on worksheet6 to take me back to the location I started at which would be worksheet1, in this case. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel/visual basic
if I have in the tab order Sheet1 Sheet2 Sheet3
and I have Sheet2 as the active sheet, Activesheet.Previous.Select selects sheet1. If you want to select Sheet3, then it would be Activesheet.Next.Select You must have a different definition of Previous than Excel. With either, you get an error if you try to select a sheet that doesn't exist. -- Regards, Tom Ogilvy "Mara Campos" wrote in message ... That code (Activesheet.previous.Select) will take me one worksheet ahead not to the previous worksheet I was on "last worksheet". Can you help me with that? Ex: I have links on worksheet1 that will direct me to diagrams in worksheet 6 but want the command button on worksheet6 to take me back to the location I started at which would be worksheet1, in this case. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Visual BASIC in Excel | Excel Worksheet Functions | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Excel and Visual Basic | Excel Discussion (Misc queries) | |||
visual basic in excel - | Excel Discussion (Misc queries) |