Thread: Opening a workbook if not opened, going to it if already opened
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
neotokyo[_2_] neotokyo[_2_] is offline
external usenet poster
  
Posts: 1
Default Opening a workbook if not opened, going to it if already opened

Your code works great...just one problem.
When the workbook file is already open, the code makes the workboo
re-open(thus asking me if I want to save changes).
How can I change the code so that if its already open, it just leave
it on(without closing and then re-opening).


Thank

--
neotoky
-----------------------------------------------------------------------
neotokyo's Profile: http://www.excelforum.com/member.php...fo&userid=1389
View this thread: http://www.excelforum.com/showthread.php?threadid=26327

Reply With QuoteReply With Quote