Is this possible?
I have a series of Worksheets with various formulae on, and cells where data is to be entered. I have locked the formulae cells so that when I put password protection on each Worksheet the formulae cells cannot be altered by mistake - others will use the Worksheet and I don't want it corrupted.
However I normally like to enter macros on sheets to make it easier to move around, e.g.
"Go To" - to move to a particulat Cell on a Worksheet, or to a Cell in another worksheet
"Save and Close" - to save the workbook and quit the Workbook
However, the Macros won't work unless I unprotect the Worksheet. Is there a way of using Macros on a protected Worksheet?
Thanks
Graham
I have a series of Worksheets with various formulae on, and cells where data is to be entered. I have locked the formulae cells so that when I put password protection on each Worksheet the formulae cells cannot be altered by mistake - others will use the Worksheet and I don't want it corrupted.
However I normally like to enter macros on sheets to make it easier to move around, e.g.
"Go To" - to move to a particulat Cell on a Worksheet, or to a Cell in another worksheet
"Save and Close" - to save the workbook and quit the Workbook
However, the Macros won't work unless I unprotect the Worksheet. Is there a way of using Macros on a protected Worksheet?
Thanks
Graham