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 |
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 |
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 |
All times are GMT +1. The time now is 06:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com