Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SORT DATA ON A PROTECTED WORKSHEET!
Hi,
is there a way of allowing all users to sort data using a macro function (key stroke or linked to an object) whilst having the worksheet protected to stop formulas ect. being tampered with / ruined! Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SORT DATA ON A PROTECTED WORKSHEET!
Hi,
When protecting the sheet you under where you enter the password, there is an option that says " Allow all users of this worksheet to" there check sort if this helps please clikc yes, thanks "Romileyrunner1" wrote: Hi, is there a way of allowing all users to sort data using a macro function (key stroke or linked to an object) whilst having the worksheet protected to stop formulas ect. being tampered with / ruined! Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SORT DATA ON A PROTECTED WORKSHEET!
Hi, I`ve ticked that box and it doesn`t seem to allow the sort whenthe sheet
is password protected. If I protect it without a password and write the macro which unprotects , sorts then re-protects : then that is fine. But is there a way to do it with a password prtected sheet (without it asking for the password again!!!) I think I`m on Excell 2003. Thanks RR1 "Eduardo" wrote: Hi, When protecting the sheet you under where you enter the password, there is an option that says " Allow all users of this worksheet to" there check sort if this helps please clikc yes, thanks "Romileyrunner1" wrote: Hi, is there a way of allowing all users to sort data using a macro function (key stroke or linked to an object) whilst having the worksheet protected to stop formulas ect. being tampered with / ruined! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sort in a protected worksheet. | Excel Discussion (Misc queries) | |||
How do I sort a protected worksheet? | Excel Discussion (Misc queries) | |||
Sort Columns in Protected Worksheet, etc. | Excel Worksheet Functions | |||
How to Sort Protected Worksheet | Excel Worksheet Functions | |||
Is it possible to sort a protected worksheet? | Excel Discussion (Misc queries) |