Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using Office 2000 and have a table with about 20 columns & 64
rows. Data is inputted into 18 of the columns from time to time, the other 2 columns being calculations based on the inputted data. In order to prevent inputting from overriding the formulae, in error, I want to protected the 2 calculated columns. However, I also want to sort the table, by macro, using the calculated columns as the sorting basis. I can get a macro to work OK if there is no protection. Is there a way to do what I want. Thanks for any help. JD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to unlock and lock cells in password protected sheet | Excel Discussion (Misc queries) | |||
Macro to clear checkboxes and protected cells | Excel Worksheet Functions | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
use macro button to run macro in protected sheet | Excel Discussion (Misc queries) |