Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
=hyperlink causes file opening to change window size
I have a worbook that has an OPEN event to make the window size half the
available width. If I open a file from a cell via =hyperlink the workbook window is always full width. Adding a worksheet activate event to resize the window fixes the problem, but..........there are too many workbooks to go through and a an activate event. Is there something I could do with a followhyperlink event in the workbook that I'm calling from? This particular workbook (TOOLS) has hyperlinks to my entire life, so I don't really want to add activate events to everything. Furthermore, even though I have folder options set to open folders in the SAME window, whenevr I open a folder from TOOLS via a hyperlink, it comes up in a separate and very annoying window (particularly if I've drilled down 2 or 3 levels). Regards Brett. (Yes Jim, I'm still at it) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
=hyperlink causes file opening to change window size
Yopu can install a hyperlink in a cell two ways:
1. Insert Hyperlink 2. use the =HYPERLINK() function Many coders prefer the function, because it gives better control of the link. HOWEVER, using the function puts you outside the Object Model. That is, if you click a function-type hyperlink, no event will occur. -- Gary''s Student - gsnu200835 "Brettjg" wrote: I have a worbook that has an OPEN event to make the window size half the available width. If I open a file from a cell via =hyperlink the workbook window is always full width. Adding a worksheet activate event to resize the window fixes the problem, but..........there are too many workbooks to go through and a an activate event. Is there something I could do with a followhyperlink event in the workbook that I'm calling from? This particular workbook (TOOLS) has hyperlinks to my entire life, so I don't really want to add activate events to everything. Furthermore, even though I have folder options set to open folders in the SAME window, whenevr I open a folder from TOOLS via a hyperlink, it comes up in a separate and very annoying window (particularly if I've drilled down 2 or 3 levels). Regards Brett. (Yes Jim, I'm still at it) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
=hyperlink causes file opening to change window size
OK, thanks GS. Damn. Do you have any thoughts on the separate window for each
folder opening, or is that part of the same scope?. Regards, Brett "Gary''s Student" wrote: Yopu can install a hyperlink in a cell two ways: 1. Insert Hyperlink 2. use the =HYPERLINK() function Many coders prefer the function, because it gives better control of the link. HOWEVER, using the function puts you outside the Object Model. That is, if you click a function-type hyperlink, no event will occur. -- Gary''s Student - gsnu200835 "Brettjg" wrote: I have a worbook that has an OPEN event to make the window size half the available width. If I open a file from a cell via =hyperlink the workbook window is always full width. Adding a worksheet activate event to resize the window fixes the problem, but..........there are too many workbooks to go through and a an activate event. Is there something I could do with a followhyperlink event in the workbook that I'm calling from? This particular workbook (TOOLS) has hyperlinks to my entire life, so I don't really want to add activate events to everything. Furthermore, even though I have folder options set to open folders in the SAME window, whenevr I open a folder from TOOLS via a hyperlink, it comes up in a separate and very annoying window (particularly if I've drilled down 2 or 3 levels). Regards Brett. (Yes Jim, I'm still at it) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
=hyperlink causes file opening to change window size
Brett,
I added a msgbox to the workbook open event of a workbook. I opened the workbook using a hyperlink formula and insert hyperlink. (by clicking them from a worksheet cell) The msgbox was displayed no matter which link was clicked. -- Jim Cone Portland, Oregon USA (MS dumped about 400 newsgroup messages, this morning, into my Outlook Express - dated 02/27/2009 and on) "Brettjg" wrote in message I have a worbook that has an OPEN event to make the window size half the available width. If I open a file from a cell via =hyperlink the workbook window is always full width. Adding a worksheet activate event to resize the window fixes the problem, but..........there are too many workbooks to go through and a an activate event. Is there something I could do with a followhyperlink event in the workbook that I'm calling from? This particular workbook (TOOLS) has hyperlinks to my entire life, so I don't really want to add activate events to everything. Furthermore, even though I have folder options set to open folders in the SAME window, whenevr I open a folder from TOOLS via a hyperlink, it comes up in a separate and very annoying window (particularly if I've drilled down 2 or 3 levels). Regards Brett. (Yes Jim, I'm still at it) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
=hyperlink causes file opening to change window size
Hi Jim, sorry, I'm not quite sure what you're saying there. However, I added
a msgbox in the open event (for the hell of it). When the msgbox is displayed the window is at the correct width, I click ok to msg and then the screen goes to full width (as a result of being opened by =hyperlink). Screen updating is set before the msgbox *as below) I can add a workshet activate event to the masters, but it's all the old ones that concern me. wb open() blah blah Application.ScreenUpdating = True MsgBox "" Also, do you have any idea why my folders are now opening in separate windows (options set to same window)? This only happens when I open a folder with =hyperlink. This is soundng a bit fishy, esp in conjunction with file open problem. Regards, Brett "Brettjg" wrote: OK, thanks GS. Damn. Do you have any thoughts on the separate window for each folder opening, or is that part of the same scope?. Regards, Brett "Gary''s Student" wrote: Yopu can install a hyperlink in a cell two ways: 1. Insert Hyperlink 2. use the =HYPERLINK() function Many coders prefer the function, because it gives better control of the link. HOWEVER, using the function puts you outside the Object Model. That is, if you click a function-type hyperlink, no event will occur. -- Gary''s Student - gsnu200835 "Brettjg" wrote: I have a worbook that has an OPEN event to make the window size half the available width. If I open a file from a cell via =hyperlink the workbook window is always full width. Adding a worksheet activate event to resize the window fixes the problem, but..........there are too many workbooks to go through and a an activate event. Is there something I could do with a followhyperlink event in the workbook that I'm calling from? This particular workbook (TOOLS) has hyperlinks to my entire life, so I don't really want to add activate events to everything. Furthermore, even though I have folder options set to open folders in the SAME window, whenevr I open a folder from TOOLS via a hyperlink, it comes up in a separate and very annoying window (particularly if I've drilled down 2 or 3 levels). Regards Brett. (Yes Jim, I'm still at it) |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
=hyperlink causes file opening to change window size
Brett,
Maybe, I misread your complaint. I was pointing out that the workbook open event does fire when a workbook is opened via a hyperlink. Something for you to try is to place the window sizing code in a general module and call it at the end of the workbook open code. As far as a multiple windows opening problem, I doubt if I can help. However, you need to define what you mean... Multiple windows in the same window (windows1 and windows2); or A separate instance of excel opens with the workbook; or The "ShowWindowsInTaskbar" property gets set to true; or ? -- Jim Cone Portland, Oregon USA "Brettjg" wrote in message Hi Jim, sorry, I'm not quite sure what you're saying there. However, I added a msgbox in the open event (for the hell of it). When the msgbox is displayed the window is at the correct width, I click ok to msg and then the screen goes to full width (as a result of being opened by =hyperlink). Screen updating is set before the msgbox *as below) I can add a workshet activate event to the masters, but it's all the old ones that concern me. wb open() blah blah Application.ScreenUpdating = True MsgBox "" Also, do you have any idea why my folders are now opening in separate windows (options set to same window)? This only happens when I open a folder with =hyperlink. This is soundng a bit fishy, esp in conjunction with file open problem. Regards, Brett |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
=hyperlink causes file opening to change window size
Hi Jim - re multiple windows. If I open a folder by clicking an =hyperlink
cell, and then open a sub folder in the folder that I've just opened by clicking on the subfolder icon, it opens up in a separate window, even though folder options is set to the same window. "Jim Cone" wrote: Brett, Maybe, I misread your complaint. I was pointing out that the workbook open event does fire when a workbook is opened via a hyperlink. Something for you to try is to place the window sizing code in a general module and call it at the end of the workbook open code. As far as a multiple windows opening problem, I doubt if I can help. However, you need to define what you mean... Multiple windows in the same window (windows1 and windows2); or A separate instance of excel opens with the workbook; or The "ShowWindowsInTaskbar" property gets set to true; or ? -- Jim Cone Portland, Oregon USA "Brettjg" wrote in message Hi Jim, sorry, I'm not quite sure what you're saying there. However, I added a msgbox in the open event (for the hell of it). When the msgbox is displayed the window is at the correct width, I click ok to msg and then the screen goes to full width (as a result of being opened by =hyperlink). Screen updating is set before the msgbox *as below) I can add a workshet activate event to the masters, but it's all the old ones that concern me. wb open() blah blah Application.ScreenUpdating = True MsgBox "" Also, do you have any idea why my folders are now opening in separate windows (options set to same window)? This only happens when I open a folder with =hyperlink. This is soundng a bit fishy, esp in conjunction with file open problem. Regards, Brett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i change the default size of a window when it opens | Excel Discussion (Misc queries) | |||
Hyperlink opening a new window | Excel Discussion (Misc queries) | |||
Code to Follow Hyperlink to media player without a new window opening | Excel Programming | |||
Default Opening Window Size? | Excel Discussion (Misc queries) | |||
About disabling Excel window size-change ... | Excel Programming |