Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Force linked spreadsheet to open in fullsized window?
I have one spreadsheet which contains a link to another spreadsheet. Click
on the (icon) link and the linked spreadsheet opens in a small window. Is there any way that I can force this second (linked) spreadsheet to open in a full size window? -- Patricia D |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Force linked spreadsheet to open in fullsized window?
HELP?? Can I assume from the lack of response that this is not possible? I
can workaround with a macro, but it doesn't work consistently. -- Patricia D "Patricia D" wrote: I have one spreadsheet which contains a link to another spreadsheet. Click on the (icon) link and the linked spreadsheet opens in a small window. Is there any way that I can force this second (linked) spreadsheet to open in a full size window? -- Patricia D |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Force linked spreadsheet to open in fullsized window?
Patricia D Wrote: I have one spreadsheet which contains a link to another spreadsheet. Click on the (icon) link and the linked spreadsheet opens in a small window. Is there any way that I can force this second (linked) spreadsheet to open in a full size window? -- Patricia DHi Patricia, You can try this. Put it in the "Worksheet Module" of the "second (linked) spreadsheet" Private Sub Worksheet_Activate() Application.DisplayFullScreen = True End Sub Private Sub Worksheet_Deactivate() Application.DisplayFullScreen = False End Sub -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=562315 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to force a pop up when spreadsheet is open? | Excel Discussion (Misc queries) | |||
windows explorer will not open an excel spreadsheet. | Excel Discussion (Misc queries) | |||
How to open a spreadsheet with Macros disabled | Excel Discussion (Misc queries) | |||
#REF error on linked spreadsheet | Links and Linking in Excel | |||
How do I force a hyperlink in a spreadsheet to open a new window? | Excel Worksheet Functions |