LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Change passwords on fly

Using Office 2003 and Windows XP;

Is it possible to code a workbook to alter or change its sheet, workbook,
and module protection passwords on the fly? I would like to tie the change
trigger to the workbook's Open event.

I already know about the weaknesses involved in using Office passwords; this
is just an extra measure to go one step further to prevent prying eyes and
mistakes;

Example VBA would be most appreciated.
 
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
Passwords change with version 2003 and 2007 SusanB Excel Discussion (Misc queries) 0 August 4th 09 08:43 PM
Add-ins passwords bad_boyu Excel Programming 1 June 11th 06 06:58 AM
Passwords dhightow Excel Discussion (Misc queries) 0 April 24th 06 08:22 PM
Change passwords Multiple sheets bbc1 Excel Discussion (Misc queries) 1 December 24th 05 02:00 AM
Passwords Black Jack Excel Programming 1 June 29th 05 03:03 AM


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