unhide hidden window or workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

make hidden window or workbook visible without specify the name 1
hiding an image 2
Workbook_BeforeSave 8
MS Excel unhiding columns tip 1
Macro that will always hide / unhide next column 2
My Workbook is always hidden when I open it? 9
Still more on loading a .CSV into a .XSLS 15
VBA keyboard action, formatt no, no info windows 1

Back
Top