Disable Macro Option

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Does anyone know how I can set my workbook to open without
giving the user the option of enabling or disabling the
macros I created?
 
Hi
you can't do this in your workbook as this is a security feature. The
user may set his security level to 'Low' but this could/would have
security drawbacks
 
You can't. Just think about the field day virus writers would have if you
could do that.

A commonly used technique is to make the key sheet hidden, and have some
workbook open code that makes it visible. Put some text on another sheet
warning the users about disabling macros and save it with this sheet active.
Not foolproof, but it helps.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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

To Enable Macro in Excel. 2
Macros disabled, not by security settings? 5
Macro Activation 2
security, enabling macros to enable a disabling saving function 12
Excel Macro Settings 1
Copy & Paste from One Workbook to a Macroed Template Workbook 1
VBE is disabled 5
Addin not allowing thisworkbook.save in before save event 3

Back
Top