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: 28
Default Protection problem macro

Hi All...........

Would it be possible to have a Macro that would, upon opening a workbook,
just sit there and wait, whether the user does some cell entries or not,
but when they particularly do the sequence Tools Protection and either
"Unprotect sheet" or "Unprotect workbook" the macro would come alive and
cause the whole workbook to close without saving......."unless" the user had
entered the code "1.5" in a particular cell (say F3) before they did that
sequence? Or, if this isn't feasible, perhaps another method that would
prevent a "password busting" programs from working.

Any help would be much appreciated.

Vaya con Dios,
Chuck, CABGx3




 
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
Excel Data Protection- AKA: Sheet/Macro Password Protection Mushman(Woof!) Setting up and Configuration of Excel 0 December 29th 09 06:50 AM
Problem with protection of cells Paul Excel Discussion (Misc queries) 3 October 30th 06 02:36 PM
VB Protection problem Rmagic Excel Worksheet Functions 1 November 22nd 05 10:27 PM
Protection Problem Dave123 Excel Discussion (Misc queries) 1 October 3rd 05 06:45 PM
sheet protection problem Deer Hunter Excel Programming 2 August 13th 03 10:47 AM


All times are GMT +1. The time now is 07:43 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"