Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Password Reminder
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 26th, 2005, 09:06 AM
Registered User
Join Date: Apr 2005
Location: Bristol, , United Kingdom.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Protection

Im having great difficulty figuring out the new security features with Excel 2003.
Im using a macro that opens a template file which is pre-locked for viewing only using the setting found under 'tools-options-security tab'.
The macro uses the writeResPassword parameter when opening the template to allow editing. iI then need to save a copy of the template file with changes BUT without any protection whatsoever. I cant for the life of me figure out how to turn off or delete the password protection.
Ive tried the setting writeResPassword to "" when saving, and various other options such as using unProtectSharing, but all seem to do absolutley nothing.
The other option would be to protect the individual sheets and unlock them all on opening, but Id rather not do that as it seems very clumsy.
Frankly i think Microsoft have done a bit of an overkill with the protection features, as now its not user friendly in the slightest.

Anyone got any ideas please??

Danger shines like sunshine in a brave mans eyes!
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
IP Code Protection Sunnysaini BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 0 May 12th, 2007 08:57 AM
DB Protection ~Bean~ SQL Language 4 October 25th, 2005 07:37 AM
Decompile Protection Eudora Servlets 0 July 18th, 2005 09:59 PM
Protection and commandButtons bahachin Excel VBA 3 March 4th, 2005 09:27 AM
Protection level noman77 .NET Framework 2.0 0 October 23rd, 2004 07:33 AM

All times are GMT -4. The time now is 06:26 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.