Why is AutoSum iinoperable w/protection when column is unlocked?


R

RSE

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!
 
Ad

Advertisements

L

Luke M

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.
 
Ad

Advertisements

C

CellShocked

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top