if worksheet already open then dont open again

**vipulhumein** · 05-20-2013, 10:19 AM

I have made two worksheet linked with each other...when i click button "open my sheet" other worksheet automatically open in invisible mode and again if i click button "open my sheet' then a msg appears "you have already open the spec file do u want to reopen again.yes or no"..i want that if my "spec file already open " then dont open again...and the msg does not appear again..

also find the picture of the said msg which i have attached.

please help me out of this problem as soon as possible

thanks in advance..

**patel45** · 05-20-2013, 11:02 AM

WorKSheet or Workbook ? you can not open a WorKSheet, you can activate it.
Attach please a sample Workbook, not images

**HaHoBe** · 05-20-2013, 11:14 AM

Hi, vipulhumein,

how about answering the suggestions in http://www.excelforum.com/excel-prog...ady-open.html? To me there is no use in opening new threads like http://www.excelforum.com/excel-prog...yes-or-no.html or this one.

Ciao,
Holger

**vipulhumein** · 05-20-2013, 12:17 PM

hi hahobe
the path u have given does not work , now also i got the same msg that " u have already open spec.xlsm file .do u want to reopen again. yes or no" ???
please help me out of this problem