D/EARL

The problem is if i unprotect the sheet in macro- then users might del
a row or formulas by mistake. So let me know if it can be done. I am
now trying to make this confusing relative and absolute ref in macro
and give a button image resembling 'auto sum'. I will also have
problems in writing the code in VB how to make the program know how
many cells from active cell to top to take. Your advice pls.


On Jan 30, 6:35 am, "Earl Kiosterud" wrote:
Captgnvr,

I don't think there's a direct way to enable the autosum button on a
protected sheet. You could have your own macro do this, and could be run by
any button you create on any toolbar.

--
Earl Kiosterudwww.smokeylake.com
-----------------------------------------------------------------------"CAPTGNVR" wrote in oglegroups.com...

D/EARL
Thnks ur feedback. I was wanting the autosum button which is disabled
in a protected sheet. Want to know if there are means to have a vb to
get this button enabled.

On Jan 30, 3:15 am, "Earl Kiosterud" wrote:
Capt,

If you're referring to the quick calculate thing on the status bar that
instantly sums selected cells, it works with a protected sheet. The
protection (Tools - Protection - Protect Sheet) has to have allowed cell
selection.

If you mean the Autosum button that puts =SUM(hethere) into a cell,
you
can't do that in a protected sheet; the Autosum button is disabled. You
could do it manually by typing =SUM( then dragging your range, then type
the
closing ).
--
Earl Kiosterudwww.smokeylake.com
-----------------------------------------------------------------------"CAPTGNVR"
wrote in
oglegroups.com...

Dear Programmers

I have some group of cells which keeps varying and would be nicer to
have the AUTOSUM on a protected sheet. Pls suggest

BRGDS/CAPT GN VENKAT RAJARAM