| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| password protect unhide sheet command | Excel Discussion (Misc queries) | |||
| Protect Sheet Macro | Excel Worksheet Functions | |||
| Macro to pull data with criterea for placement on a new sheet | Excel Discussion (Misc queries) | |||
| Using macro to un/protect sheet | Excel Worksheet Functions | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Hybrid Mode
