Thread: Macro in Excel to check if another workbook is opened.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Catalin[_3_] Catalin[_3_] is offline
external usenet poster
  
Posts: 1
Default Macro in Excel to check if another workbook is opened.

Hi to all and each one.

I'm looking to make a macro in VBA for the purposed posted below:

When I open the workbook "X", the macro should check if the workboo
"Y" is opened already. If not, either a message box should appear o
the workbook "Y" should be open.

Thanks in advance,
Catali

--
Catali
-----------------------------------------------------------------------
Catalin's Profile: http://www.excelforum.com/member.php...fo&userid=3689
View this thread: http://www.excelforum.com/showthread.php?threadid=56857

Reply With QuoteReply With Quote