Excel Macro / VBA to pull up the protect sheet command
 

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?

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?

Excel Macro / VBA to pull up the protect sheet command
 

Show the Excel dialog :
Application.Dialogs(xlDialogProtectDocument).Show

NickHK

wrote in message
oups.com...
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?