LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Disable ability to Protect

Hi All........
If this is possible, I could use some help please.
1-User opens file and un-protects with password, and makes changes to sheet.
2-Tools Protection selection is disabled so user cannot re-invoke
Protection and insert their own password.
3-Before-save macro re-enables the Tools Protection selection and invokes
Sheet Protection with "MyOriginalPassword"

Any help/suggestions would be 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
is it possible to disable the ability to save a file unless the u. AucklandAssault Excel Discussion (Misc queries) 2 November 8th 06 08:52 PM
Disable Tools Protection Protect Sheet for all users but one Win XP Excel Discussion (Misc queries) 6 January 17th 06 10:46 PM
Disable Tools, Protect, Protect Workbook Paul Moles Excel Programming 1 September 5th 05 03:37 PM
Disable/Protect Cells based on If bforster1[_15_] Excel Programming 1 September 29th 04 04:36 PM
combo box web ability matt Excel Programming 0 August 1st 03 07:05 PM


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