| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro on Protected sheet
G'Day MVPs, OfficeXP Excel question:
My spreadsheet will manually sort fine when it is protected but when the same sort is attempted via a macro it reports a protection conflict error. How can I workaround this problem? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro on Protected sheet
Hi Ryton,
Sheets("Sheet 1").Unprotect "Your code" Sheets("Sheet 1").Protect This will unprotect the sheet, run your macro, then protect the sheet again. Of course, change the Sheet 1 name to your sheet name. Alan "The only dumb question is the question left unasked." "Ryton" wrote in message ps.com... G'Day MVPs, OfficeXP Excel question: My spreadsheet will manually sort fine when it is protected but when the same sort is attempted via a macro it reports a protection conflict error. How can I workaround this problem? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro on Protected sheet
Thanks Alan!
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro on Protected sheet
Glad to help.
"Ryton" wrote in message oups.com... Thanks Alan! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro & Protected sheet | Excel Discussion (Misc queries) | |||
| How to get a macro to run that uses a protected sheet | Excel Programming | |||
| use macro on a protected sheet | Excel Programming | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
| Using a Macro with the sheet protected. | Excel Programming | |||
Linear Mode
