close WB after clicking DISABLE MACROS

  • Thread starter Thread starter Mario M
  • Start date Start date
M

Mario M

Hi all ,

Is there a way to close a workbook after the user clicks on the "Disable
Macros" button on the security warning screen , instead of opening the
workbook anyway.

Thanks in advance
Mario
 
No because that requires macro code.

An alternative suggestion.

Create a sheet with some text on saying that macros need to be enabled else
the workbook is unusable.
Hide all sheets except this one (in the VBIDE you can very hide them)
Add some workbook_open event code that makes all other sheets visible and
this one not visible (reverse it in the Workbook BeforeClose event and save
it)

If they disable macros, they will just get the warning screen, if they don't
all is well.
 

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

closing another file by code causes failure to run workbook activate event 2
Macros disabled, not by security settings? 5
Closing a workbook 5
Addin not allowing thisworkbook.save in before save event 3
Getting the name & path of a hidden WB 2
All Workbook Saved except This Workbook 3
access data from a closed wb protected with password without openi 6
Stop sheet showing when Using Datapig's Force Users to enable macr 1

Back
Top