Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can Excel open each workbook in a seperate window | Setting up and Configuration of Excel | |||
Resize the workbook window is impossible | Excel Discussion (Misc queries) | |||
Why cannot I unhide the hidden rows ? | Excel Discussion (Misc queries) | |||
I can't unhide 3 columns previously hidden | Excel Discussion (Misc queries) | |||
deleting second open window in a workbook | Excel Worksheet Functions |