Jill_Be_Chill
New Member
- Joined
- Nov 2, 2018
- Messages
- 1
Hi Everyone! I want to thank / apologize to everyone for being new to all of this and for your patience. This forum seems friendlier than the the others!
We have a planning document that helps the social services system to prepare a foster child for permanent adoption. It’s an xlsm format. It’s being replaced this year by better software but here we are until then.
To be clear: I have the password and the VBA password. This isn’t a password issue.
A troubled employee, our IT and VBA guru was put on leave this week. He did massive damage to our adoption processes.
After 8+ hours of researching and crash learning VBA, here is my assumption and problem: Despite the presence of no password, the Structure Protection (SP) cannot be unchecked. Thus we cannot copy data into the workbook or the Output sheet out of the workbook to do our work.
If I uncheck SP I cannot click Okay. Enabling or disabling the Macros has 0 effect.
The document has no digital signature to be removed.
This is Day 1 of VBA for me. But in diving in and opening all the pages and modules in VBE, I have used the search function against many of the VBA functions one could use to accomplish this. I used many different blogs and articles to find search terms including this one: https://stackoverflow.com/questions/3690793/how-to-protect-excel-workbook-using-vba
None of my searches came up with any of these terms exactly. It only found things in the “modules” of which there are four. There is a VBA entry with options for every sheet and one called thisworkbook. I scoured all those settings too.
The original developer is long gone. This man wants $10K to “fix it”. I have anxious parents and I’m close to tears.
Does anyone have any (kind) guidance for me?
Jill
We have a planning document that helps the social services system to prepare a foster child for permanent adoption. It’s an xlsm format. It’s being replaced this year by better software but here we are until then.
To be clear: I have the password and the VBA password. This isn’t a password issue.
A troubled employee, our IT and VBA guru was put on leave this week. He did massive damage to our adoption processes.
After 8+ hours of researching and crash learning VBA, here is my assumption and problem: Despite the presence of no password, the Structure Protection (SP) cannot be unchecked. Thus we cannot copy data into the workbook or the Output sheet out of the workbook to do our work.
If I uncheck SP I cannot click Okay. Enabling or disabling the Macros has 0 effect.
The document has no digital signature to be removed.
This is Day 1 of VBA for me. But in diving in and opening all the pages and modules in VBE, I have used the search function against many of the VBA functions one could use to accomplish this. I used many different blogs and articles to find search terms including this one: https://stackoverflow.com/questions/3690793/how-to-protect-excel-workbook-using-vba
None of my searches came up with any of these terms exactly. It only found things in the “modules” of which there are four. There is a VBA entry with options for every sheet and one called thisworkbook. I scoured all those settings too.
The original developer is long gone. This man wants $10K to “fix it”. I have anxious parents and I’m close to tears.
Does anyone have any (kind) guidance for me?
Jill
