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! |
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! |
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! |
All times are GMT +1. The time now is 07:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com