i have made two worksheet where one worksheet is linked with other whenever i open 1 worksheet the other worksheet open ...so i want that if the other worksheet open already than dont open again and dont show me the msg " that the other worksheet already open. do u want to reopen again. Yes no"
please help me out of this problem
thanks in advance
Hi, vipulhumein,
maybe like this (code could be accessible in ThisWorkbook and Private Sub Workbook_Open):
Work with the workbook objects wbONE and wbTWO later in the code instead of switching Windows.
Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
it doesn't work after applying in this workbook .... now also the same msg came " that u have already open the other workbook, do u want to reopen again"
please help me out of this
Hi, vipulhumein,
Where´s the code you used? I can´t look into your computer I´m afraid.it doesn't work after applying in this workbook
The code assumes that you open the workbooks in the same instance of Excel, not in different ones.
Please Login or Register to view this content.Ciao,Please Login or Register to view this content.
Holger
Please Login or Register to view this content.
Elegant Simplicity............. Not Always
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks