| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Previous Sheet
Hi,
I am using the next function ActiveSheet.Previous.Activate with a button to move to the previous sheet. The button is on every sheet and should always go back till the first one. All works fine until i get to a sheet that doesnt go back to the one before. If i move manually and then press the button i can skip that sheet. Whats wrong? any other way of doing that? Thanks, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Previous Sheet
If Activesheet.Index 1 then Activesheet.Previous.Activate
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vandaley" wrote in message oups.com... Hi, I am using the next function ActiveSheet.Previous.Activate with a button to move to the previous sheet. The button is on every sheet and should always go back till the first one. All works fine until i get to a sheet that doesnt go back to the one before. If i move manually and then press the button i can skip that sheet. Whats wrong? any other way of doing that? Thanks, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Previous Sheet
Sorry mate but it still doesnt work.
i am stuck on the same sheet and it doesnt go back. Any idea? Bob Phillips wrote: If Activesheet.Index 1 then Activesheet.Previous.Activate -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vandaley" wrote in message oups.com... Hi, I am using the next function ActiveSheet.Previous.Activate with a button to move to the previous sheet. The button is on every sheet and should always go back till the first one. All works fine until i get to a sheet that doesnt go back to the one before. If i move manually and then press the button i can skip that sheet. Whats wrong? any other way of doing that? Thanks, |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Previous Sheet
Post all your code.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vandaley" wrote in message ups.com... Sorry mate but it still doesnt work. i am stuck on the same sheet and it doesnt go back. Any idea? Bob Phillips wrote: If Activesheet.Index 1 then Activesheet.Previous.Activate -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vandaley" wrote in message oups.com... Hi, I am using the next function ActiveSheet.Previous.Activate with a button to move to the previous sheet. The button is on every sheet and should always go back till the first one. All works fine until i get to a sheet that doesnt go back to the one before. If i move manually and then press the button i can skip that sheet. Whats wrong? any other way of doing that? Thanks, |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Previous Sheet
Bob's code works for me. Are there any hidden
worksheets? If the previous sheet is hidden then Activate (silently) fails. Andrew vandaley wrote: Sorry mate but it still doesnt work. i am stuck on the same sheet and it doesnt go back. Any idea? Bob Phillips wrote: If Activesheet.Index 1 then Activesheet.Previous.Activate -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vandaley" wrote in message oups.com... Hi, I am using the next function ActiveSheet.Previous.Activate with a button to move to the previous sheet. The button is on every sheet and should always go back till the first one. All works fine until i get to a sheet that doesnt go back to the one before. If i move manually and then press the button i can skip that sheet. Whats wrong? any other way of doing that? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transfer contents from a cell in previous sheet if the sheet is a | New Users to Excel | |||
| Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
| Add a Sheet From a Previous Sheet Macro | Excel Worksheet Functions | |||
| new sheet with same name as previous. | Excel Programming | |||
| Refer new sheet to previous sheet | Excel Worksheet Functions | |||
Hybrid Mode
