Macro to unlock VBA Properties and relock using new password

O

OfficeUser

Well-known Member
Joined
Feb 4, 2010
Messages
542
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I have about 50 workbooks I want to open, unlock the VBA properties with the current password and then re-lock with a new password and then save and close the workbook. Is this possible?
Thanks!!
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
You must log in or register to reply here.

Similar threads

N
  • Solved
Password protect column with unlock button
Replies
4
Views
393
DanteAmor
DanteAmor
J
  • Question
VBA to unlock sheet
Replies
2
Views
187
Peter_SSs
Peter_SSs
W
  • Question
multiple password protected pages with same password and using macros
Replies
0
Views
459
WindowGuy
W
C
  • Question
Hiding Sheets during the Before_Close Event
2
Replies
10
Views
289
Jaafar Tribak
Jaafar Tribak
J
  • Question
Locking Worksheet
Replies
3
Views
132
dmt32
D

Forum statistics

Threads
1,214,920
Messages
6,122,272
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top