Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello everyone
I have a sheet which is protected so that cells cannot be changed and formulas are hidden which works well. However I also have a macro on this sheet which I still want people to be able to use. (see below) I have seen some answers already but seem to be doing something wrong - what do I need to add to the below to have the macro only run but keep the actual cells locked/protected? Many thanks Sub Sort() ' ' Sort Macro ' Macro recorded 17/03/2010 by Lisa Senior ' ' Keyboard Shortcut: Ctrl+o ' Columns("A:A").Select Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End Sub -- Thanks as always Lise |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro functions in a protected sheet | New Users to Excel | |||
Macro Error when Sheet is Protected | Excel Discussion (Misc queries) | |||
macro on protected sheet-error | Excel Discussion (Misc queries) | |||
use macro button to run macro in protected sheet | Excel Discussion (Misc queries) | |||
Macro Errs when sheet is protected | Excel Worksheet Functions |