ACommandLineKindaGuy
Active Member
- Joined
- May 11, 2002
- Messages
- 378
- Office Version
- 365
- Platform
- Windows
I'd appreciate any help in automating a workbook with a number of sheets where user input data is unlocked/unhidded, and each sheet protected. What I'd like to do is develop macros that:
1. Delete user input in a particular sheet only by deleting all cells that are unlocked/unhidden by pressing a button in that sheet.
2. Unprotect all sheets, select all sheets, select all cells of all sheets, right-click copy, and right-click paste special-values so that all sectret-type formulas are replaced by the value they calculate. I can then save the workbook under a new name and distribute it to others.
3. Select active sheets (what I call active sheets are sheets with a particular named cell >0 (eg SBC!AA6 = SBCCost = $12,430,000)
and print them.
Thanks in advance for any consideration of these questions. Back in the days of 1-2-3 v. 2.4 I could do this kind of stuff--I guess this ole dawg isn't up to learning VB--or at least is intimidated by it!
1. Delete user input in a particular sheet only by deleting all cells that are unlocked/unhidden by pressing a button in that sheet.
2. Unprotect all sheets, select all sheets, select all cells of all sheets, right-click copy, and right-click paste special-values so that all sectret-type formulas are replaced by the value they calculate. I can then save the workbook under a new name and distribute it to others.
3. Select active sheets (what I call active sheets are sheets with a particular named cell >0 (eg SBC!AA6 = SBCCost = $12,430,000)
and print them.
Thanks in advance for any consideration of these questions. Back in the days of 1-2-3 v. 2.4 I could do this kind of stuff--I guess this ole dawg isn't up to learning VB--or at least is intimidated by it!