LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mango
 
Posts: n/a
Default unhide hidden window or workbook

dear all,

first i unhide the window in a module A

MyPath2 = "\\server_app\budget\abc.xls#'bbb'!a1"
Set xlx = Workbooks.Open("\\server_app\budget\abc.xls", UpdateLinks:=0)
ActiveWorkbook.FollowHyperlink (MyPath2)
ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollRow = 1
ActiveWindow.Visible = False

later i want to unhide using macro shortcut key in module B
ActiveWindow.Visible = true

but it would work as i think it isn't a activewindow now. what should i use
to unhide or make this visible? i do this for presentation.
first of all i call out and hide it then when come to this topic i will
unhide it.
pls help.

thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel open each workbook in a seperate window JVC Dude Setting up and Configuration of Excel 2 January 15th 05 01:01 AM
Resize the workbook window is impossible Valeria Excel Discussion (Misc queries) 1 December 29th 04 11:30 AM
Why cannot I unhide the hidden rows ? Jim Edwards Excel Discussion (Misc queries) 2 December 4th 04 04:38 PM
I can't unhide 3 columns previously hidden Kozul Excel Discussion (Misc queries) 1 December 3rd 04 05:15 AM
deleting second open window in a workbook mark in leisure Excel Worksheet Functions 2 November 8th 04 02:09 PM


All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"