Delete Password protected macros

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have done a lot of searching and I have found that it doesn't seem
to be possible for a macro to be able to access the password
attributes for it's project in Excel.

I am trying to figure out a way to keep my macros protected, and at
the same time give the users the ability to delete all macros in a
project. I have tried to create macros that delete all of the other
macros, but it still doesn't work unless you unlock the macros with
the password first. Does anyone have a suggetion on what I can do?

Thanks,
Matt
 
Maybe move your code to an addin--so the workbook doesn't have any code in it.

Or if you don't have any code behind the ThisWorkbook or worksheets or forms
or...

Just give them one more macro that copies the sheets they need to a new
workbook.
 
Try selecting all sheets and copying to a new workbook.

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
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

How to Unlock Excel Workbook protected by MACRO Password 6
including macro in protected worksheet 2
Removing pasword-protected macro 4
not able to enable macro in password protected .xlsm workbook. 2
How do i password protect my VB Code from users 2
Macros and Password Protection 6
Novice - using macro to protect with password 10
Open password protected file with macros 2

Back
Top