Excel Macro / VBA to pull up the protect sheet command

P

ppaauull

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting sheet in a macro doesn't work 1
"How do I un/protect sheet by macro program with password 5
How do i password protect my VB Code from users 2
protect sheet with password 2
Controlling worksheet protection via VBA 0
Command Button Macro to Expand/Collapse Grouped Columns 4
Macro Programming with Sorting 2
Novice - using macro to protect with password 10

Top