Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is AutoSum iinoperable w/protection when column is unlocked?
I have a spreadsheet with certain cells containing formulas. I want to lock
those cells and have them skipped over by the user. There are other fields where data MUST be entered. There is also a blank column where the user can copy cells and do their own calculations. This entire column is unlocked. However, as soon as I protection the sheet, stating that they cannot access locked cells, but can select and format unlocked cells, AUTOSUM is shaded out and does not work!. If I turn off the protection, it works again. HELP! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is AutoSum iinoperable w/protection when column is unlocked?
While I agree it is odd that XL doesn't give you the button option, do note
that the keyboard shortcut still works (Alt plus the +/= key) If you really want a button, you could create this simple macro: Sub MyAutoSum() 'Performs the keyboard shortcut of AutoSum Application.SendKeys "%=" End Sub and then assign it to a custom button on your toolbar. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RSE" wrote: I have a spreadsheet with certain cells containing formulas. I want to lock those cells and have them skipped over by the user. There are other fields where data MUST be entered. There is also a blank column where the user can copy cells and do their own calculations. This entire column is unlocked. However, as soon as I protection the sheet, stating that they cannot access locked cells, but can select and format unlocked cells, AUTOSUM is shaded out and does not work!. If I turn off the protection, it works again. HELP! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is AutoSum iinoperable w/protection when column is unlocked?
On Fri, 6 Nov 2009 05:29:01 -0800, Luke M
wrote: While I agree it is odd that XL doesn't give you the button option, do note that the keyboard shortcut still works (Alt plus the +/= key) If you really want a button, you could create this simple macro: Sub MyAutoSum() 'Performs the keyboard shortcut of AutoSum Application.SendKeys "%=" End Sub and then assign it to a custom button on your toolbar. Can I assign a simple standard function to a button without a macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I autosum a filtered column | Excel Worksheet Functions | |||
autosum on a column | Excel Discussion (Misc queries) | |||
Why does a column add incorrectly when usng autosum? | Excel Worksheet Functions | |||
Macro code to autosum a dynamic length column | Excel Discussion (Misc queries) | |||
How do I Autosum a running column total in excel? | Excel Worksheet Functions |