View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ppaauull@gmail.com is offline
external usenet poster
 
Posts: 2
Default Excel Macro / VBA to pull up the protect sheet command

NM.. figured it out:

SendKeys "%TPP"

thanks.


wrote:
I'm trying to set up a macro that will pull up the default password box
for "protect sheet" and "unprotect sheet" command (tools-protection),
but I'm unable to macro it, and I'm not very proficient with VBA, can
someone help me out?