View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikeburg[_61_] mikeburg[_61_] is offline
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