View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nick-ipswich nick-ipswich is offline
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.