Wrox Programmer Forums
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
Old April 26th, 2005, 09:06 AM
Registered User
Join Date: Apr 2005
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!

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

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