?
Solved

Password remover macro

Posted on 2014-11-03
9
Medium Priority
?
149 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 1800 total points
ID: 40419820
0
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 200 total points
ID: 40419821
Is it the same password for all sheets?
0
 

Author Comment

by:Frank Freese
ID: 40419859
Yes - same password
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Frank Freese
ID: 40419925
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
 

Author Closing Comment

by:Frank Freese
ID: 40419929
thanks folks
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40419947
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
ID: 40419990
I assumed you knew the password!
0
 

Author Comment

by:Frank Freese
ID: 40420148
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
ID: 40421072
I realise that, but if you knew the password, the code doesn't need to be anywhere near as complicated.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

616 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