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 September 21st, 2006, 07:13 AM
Authorized User
 
Join Date: Sep 2006
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default EXCEL SHEET SECURITY

//THIS IS WORKING FINE
Sheets(“sheetname”).UnProtect password:=”password”
...your macros….
Sheets(“sheetname”).Protect password:=”password”

//WHY THIS IS NOT WORKING
Sheets(“sheetname”).UnProtect userinterfaceonly:=true
..your macros…


ASAP
Thanks&Regards
Kotaiah.K
mail id: katragaddakv@gmail.com




 
Old February 21st, 2013, 08:45 AM
Registered User
 
Join Date: Feb 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default EXCEL SHEET SECURITY

Hello kotaiah

Use PDS Excel password recovery software and remove excel file security ........





Similar Threads
Thread Thread Starter Forum Replies Last Post
how to save as an excel sheet azizsaad19 Beginning VB 6 2 May 25th, 2007 09:48 AM
Non Editable Excel Sheet kotaiah Excel VBA 0 September 13th, 2006 03:46 AM
Excel Sheet Security ASAP kotaiah Excel VBA 0 September 12th, 2006 10:51 AM
Excel Sheet Security kotaiah Excel VBA 0 September 12th, 2006 10:46 AM
write multi-sheet Excel w/o Excel.Application manmoth Classic ASP Components 2 November 22nd, 2005 10:56 AM





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