Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 11-07-2012, 05:19 AM
Gratje Gratje is offline Unhiding a workbook and activating it in VBA Windows 7 64bit Unhiding a workbook and activating it in VBA Office 2007
Novice
Unhiding a workbook and activating it in VBA
 
Join Date: Apr 2012
Posts: 3
Gratje is on a distinguished road
Default

Hi Paul,
The option you mentiond about using the hyperlink function i.s.o. a direct hyperlink looks very promising. I ran a quick test and it looks like it is working the way I want it. With the hyperlink function, file3 is opened and becomes the activated window while file1 stays in the background. file2 is not needed this way and that would be perfect. I need to test it in the actual file where we want the link but since I don't have rights to modify this file myself, this has to wait till friday when my colleague is back. I'l let you know what the outcome will be.
So far I want to thank you for your time to help me.

Best regards,
Gerard
Reply With Quote
 

Tags
activate, unhide, workbook



Similar Threads
Thread Thread Starter Forum Replies Last Post
Unhiding a workbook and activating it in VBA #REF! error when opening a workbook that contain a refference to another workbook tanababa Excel 2 06-07-2012 03:11 PM
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? tinfanide Excel Programming 1 02-09-2012 04:08 PM
Unhiding a column Maureen Excel 3 09-16-2011 08:57 AM
Unhiding a workbook and activating it in VBA macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM
Unhiding a workbook and activating it in VBA Select a range in one one workbook while working in other workbook Slow&Steady Excel 1 02-21-2010 03:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft