Cancel workbook opening

  • Thread starter Thread starter Venkat
  • Start date Start date
V

Venkat

Hi,

I need to cancel workbook opening based on some conditions. Is there any
way to cancel workbook opening? I checked there is no event like
BeforeWorkbookOpen event. If it exists then we can cancel the workbook
opening.

Cheers,
Venkat
 
Perhaps you can an AutoOpen macro to close the workbook if your
conditions call for it. What kind of conditions need to exist to keep
you from opening this workbook?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Excel Providing user message when RED X clicked & properly closing application. 2
Rundll Error 0
Mandatory Cell completion for multiple worksheets in a workbook 0
Macro that opens a separate workbook to a specified worksheet whenthe active workbook is right mouse 8
open every workbook in a new instance of excel 2
How to create absolute link to cell in another workbook (Excel 2003) 1
Excel 2007 & XP/Vista 1

Back
Top