Solved

Password remover macro

Posted on 2014-11-03
9
108 Views
Last Modified: 2014-11-04
Folks,
I've been "muddling" with not much success in trying to create a macro that will allow me to:
1. Remove the password from a worksheet
2. Remove all passwords from a workbook
0
Comment
Question by:Frank Freese
  • 4
  • 3
  • 2
9 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 450 total points
Comment Utility
0
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 50 total points
Comment Utility
Is it the same password for all sheets?
0
 

Author Comment

by:Frank Freese
Comment Utility
Yes - same password
0
 

Author Comment

by:Frank Freese
Comment Utility
Glenn,
Well it worked but for the life of me I'd never have figured that out. WOW - one would think there's an easier way. But I'm grateful, regardless.
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Closing Comment

by:Frank Freese
Comment Utility
thanks folks
0
 
LVL 27

Expert Comment

by:Glenn Ray
Comment Utility
It's not supposed to be easy.  But I've used the AllInternalPasswords macro a few times myself and it's come in handy.
0
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
I assumed you knew the password!
0
 

Author Comment

by:Frank Freese
Comment Utility
Rory,
The macro I got from Glenn actually remove the password so that's ok. thanks for wanting to help. I appreciate it
0
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
I realise that, but if you knew the password, the code doesn't need to be anywhere near as complicated.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now