software

Is there a way to protect a worksheet so that data can't be changed or
deleted, but give the user freedom to format as they wish, i.e. hide columns,
etc.?

Connie


Different versions of excel enable you to have different levels of
protection... What version are you using?--
wmaughan
------------------------------------------------------------------------
wmaughan's Profile: www.excelforum.com/member.php...oamp;userid=29743
View this thread: www.excelforum.com/showthread...hreadid=496389Excel 2000 (9.0.7616 SP-3)

quot;wmaughanquot; wrote:

gt;
gt; Different versions of excel enable you to have different levels of
gt; protection... What version are you using?
gt;
gt;
gt; --
gt; wmaughan
gt; ------------------------------------------------------------------------
gt; wmaughan's Profile: www.excelforum.com/member.php...oamp;userid=29743
gt; View this thread: www.excelforum.com/showthread...hreadid=496389
gt;
gt;

xl2002 offered lots more options when protecting sheets.

Maybe you could provide macros that the users could run when they want to change
stuff.

Your macro could unprotect the sheet, do the formatting changes and then
reprotect the sheet.
Connie Martin wrote:
gt;
gt; Excel 2000 (9.0.7616 SP-3)
gt;
gt; quot;wmaughanquot; wrote:
gt;
gt; gt;
gt; gt; Different versions of excel enable you to have different levels of
gt; gt; protection... What version are you using?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; wmaughan
gt; gt; ------------------------------------------------------------------------
gt; gt; wmaughan's Profile: www.excelforum.com/member.php...oamp;userid=29743
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=496389
gt; gt;
gt; gt;

--

Dave Peterson

Thank you. I think I'll wait until we upgrade to XL 2002! And who knows
when that'll be! Connie

quot;Dave Petersonquot; wrote:

gt; xl2002 offered lots more options when protecting sheets.
gt;
gt; Maybe you could provide macros that the users could run when they want to change
gt; stuff.
gt;
gt; Your macro could unprotect the sheet, do the formatting changes and then
gt; reprotect the sheet.
gt;
gt;
gt;
gt; Connie Martin wrote:
gt; gt;
gt; gt; Excel 2000 (9.0.7616 SP-3)
gt; gt;
gt; gt; quot;wmaughanquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; Different versions of excel enable you to have different levels of
gt; gt; gt; protection... What version are you using?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; wmaughan
gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; wmaughan's Profile: www.excelforum.com/member.php...oamp;userid=29743
gt; gt; gt; View this thread: www.excelforum.com/showthread...hreadid=496389
gt; gt; gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;