Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
maximize one of three minimized workbooks to certain sheet
Hi. Not sure if this can be done. At one point in my routing, I have three
workbooks that are minimized. I need to maximize one of the three and have to open on sheet two. Anyone have any ideas on how to code this? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
maximize one of three minimized workbooks to certain sheet
SLP,
Try Windows("your workbook name").activate sheets("Sheet2").select "SLP" wrote: Hi. Not sure if this can be done. At one point in my routing, I have three workbooks that are minimized. I need to maximize one of the three and have to open on sheet two. Anyone have any ideas on how to code this? Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
maximize one of three minimized workbooks to certain sheet
Thanks for the response. I thought about that but the problem is the
workbook used by many people who will save it with a different name. (Its a budget tool.) Would a wildcard work for a file name? I could probably tell everyone just to enter their initials or something after the workbook name. "JRForm" wrote: SLP, Try Windows("your workbook name").activate sheets("Sheet2").select "SLP" wrote: Hi. Not sure if this can be done. At one point in my routing, I have three workbooks that are minimized. I need to maximize one of the three and have to open on sheet two. Anyone have any ideas on how to code this? Thanks in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
maximize one of three minimized workbooks to certain sheet
SLP,
Okaydo you have code that minimizes the workbooks? If so you can set a variable to keep the workbook name. dim Oldbook as string Oldbook=activeworkbook.name "SLP" wrote: Thanks for the response. I thought about that but the problem is the workbook used by many people who will save it with a different name. (Its a budget tool.) Would a wildcard work for a file name? I could probably tell everyone just to enter their initials or something after the workbook name. "JRForm" wrote: SLP, Try Windows("your workbook name").activate sheets("Sheet2").select "SLP" wrote: Hi. Not sure if this can be done. At one point in my routing, I have three workbooks that are minimized. I need to maximize one of the three and have to open on sheet two. Anyone have any ideas on how to code this? Thanks in advance. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
maximize one of three minimized workbooks to certain sheet
That sounds interesting. I'll give it a try and let you know. Thanks.
"JRForm" wrote: SLP, Okaydo you have code that minimizes the workbooks? If so you can set a variable to keep the workbook name. dim Oldbook as string Oldbook=activeworkbook.name "SLP" wrote: Thanks for the response. I thought about that but the problem is the workbook used by many people who will save it with a different name. (Its a budget tool.) Would a wildcard work for a file name? I could probably tell everyone just to enter their initials or something after the workbook name. "JRForm" wrote: SLP, Try Windows("your workbook name").activate sheets("Sheet2").select "SLP" wrote: Hi. Not sure if this can be done. At one point in my routing, I have three workbooks that are minimized. I need to maximize one of the three and have to open on sheet two. Anyone have any ideas on how to code this? Thanks in advance. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
maximize one of three minimized workbooks to certain sheet
Tried your suggestion and I can't make it work. I placed the variable at the
beginning of the code for that command button that starts this part of my routine and then added the dim Oldbook as string at the beginning of the code that minimizes the other workbook. Any other ideas? I'll keep at it....just in case I need to add the variable someplace else. "SLP" wrote: That sounds interesting. I'll give it a try and let you know. Thanks. "JRForm" wrote: SLP, Okaydo you have code that minimizes the workbooks? If so you can set a variable to keep the workbook name. dim Oldbook as string Oldbook=activeworkbook.name "SLP" wrote: Thanks for the response. I thought about that but the problem is the workbook used by many people who will save it with a different name. (Its a budget tool.) Would a wildcard work for a file name? I could probably tell everyone just to enter their initials or something after the workbook name. "JRForm" wrote: SLP, Try Windows("your workbook name").activate sheets("Sheet2").select "SLP" wrote: Hi. Not sure if this can be done. At one point in my routing, I have three workbooks that are minimized. I need to maximize one of the three and have to open on sheet two. Anyone have any ideas on how to code this? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
minimized excel worksheet cannot drag or maximize | Excel Discussion (Misc queries) | |||
Need code to close minimized workbooks in BeforeClose event | Excel Programming | |||
Why do minimized workbooks in Excell not show file names? | Excel Discussion (Misc queries) | |||
Why do minimized workbooks in Excell not show file names? | Excel Discussion (Misc queries) | |||
How to maximize workbooks (out of IE) | Excel Discussion (Misc queries) |