LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Require certain password for sheet1 to save


Need vba code line that will prevent a workbook from being saved if it's
sheet1 is protected with any other password than something like "lmbc".

&/or

only allow the password "lmbc" to protect sheet1.

Any ideas? Thanks so much for all your help. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=501306

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Require mandatory info input in order for Exel to save changes. VHG Excel Worksheet Functions 3 May 31st 07 12:40 PM
Require password to execute macro richinlaf31[_4_] Excel Programming 0 August 3rd 05 07:13 PM
Require Workbook to be renamed in order to Save It Steve Klenner Excel Programming 1 July 13th 05 08:45 AM
require password each time a macro is executed Marty Excel Programming 6 October 10th 04 08:13 PM
Excel VBA-How to save sheet w/in all workbooks as sheet1? waveracerr[_11_] Excel Programming 0 February 12th 04 05:40 PM


All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"