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 have macros complete and enter passwords for sheet protection.

many of my sheets are used by people seemingly with a mission to destroy them
in every way possible. hence high level of security applied sheet by sheet -
to put it in context I am entering the password 3x (1 on unprotect, 2 on
protect) 2x per week 50x sheets - so 300 times per week - but I cant figure
programming as part of macro so it will auto fill these for me - the
rationale being the macro itself would be password protected to get the same
security in 2 mouse clicks instead of 300 keyboard entries.
--
To say thanks I make a £5 charity donation for a response that provides the
fix I need. Please state which charity you wish to support. 1) nspcc 2) water
aid 3) royal british legion poppy appeal.
 
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
Excel2007 limiting Pre-2007 Worksheet protection passwords to 15 c greg.campeau Excel Discussion (Misc queries) 2 July 2nd 08 06:13 PM
Macros and Passwords Shawrie777 Excel Discussion (Misc queries) 9 December 4th 07 07:13 PM
Protection with different passwords James Russell Excel Discussion (Misc queries) 1 October 24th 07 02:18 PM
Passwords in macros Julian Glass Excel Worksheet Functions 1 October 24th 06 03:28 PM
Passwords and protection: wordtlengths? Rob[_5_] Excel Programming 3 November 19th 03 09:14 AM


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