On Friday, September 18, 2015 at 10:28:35 AM UTC+1, sheari...@gmail.com wrote:

On Thursday, January 24, 2008 at 1:18:58 AM UTC+2, Gord Dibben wrote:

That's what you would have if you followed the instructions given but only for
some cells.

For "ALL" the cells?

CTRL + a(twice in 2003) to select all cells.

Follow my instructions for unlocking and protecting.

Gord

On Wed, 23 Jan 2008 14:03:02 -0800, cmcr34 <cmc...@discussions.microsoft.com>
wrote:

I want a sheet that someone can type into the cells but the borders remain
locked.

"Gord Dibben" wrote:

By default all cells on a sheet are locked when sheet is protected.

For Excel 2002 and newer versions.......................

Select the cells to type in.......presumably these cells have borders. >>
Format>Cells>Protection. Uncheck the "Locked" option.

Tools>Protection>Protect Sheet>Allow users to:

Checkmark "select unlocked cells".

All other checkboxes remain cleared.

OK your way out.


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 13:36:01 -0800, cmcr34 <cmc...@discussions.microsoft.com>
wrote:

I want to create an exceel worksheet where the borders are protected from
copy/paste and drag/drop but the users can still type in data.

Thanks

Hi Gord,

My spreadsheet contains only thick borders. Every time I copy and paste data or text the borders change back to thin and I spend precious time redoing them back to thick. Very frustrating.

I have followed your instructions to the T but only got it right once. Seems like I can't lock the borders of the whole sheet.

Any ideas?

Thank you.

An alternative solution that is not that clean is to not use border but rather draw a colour inside a small cell. So you can insert a narrow column and fill it black to make it a border. But I agree it would be nice with the option to make the border
stay as it is almost always used to frame a certain area rather than a certain cell.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 2/15/2022 7:11 AM, Carl Heintz wrote:

On Friday, September 18, 2015 at 10:28:35 AM UTC+1, sheari...@gmail.com wrote:

On Thursday, January 24, 2008 at 1:18:58 AM UTC+2, Gord Dibben wrote:

That's what you would have if you followed the instructions given but only for
some cells.

For "ALL" the cells?

CTRL + a(twice in 2003) to select all cells.

Follow my instructions for unlocking and protecting.


Gord


On Wed, 23 Jan 2008 14:03:02 -0800, cmcr34 <cmc...@discussions.microsoft.com>
wrote:

I want a sheet that someone can type into the cells but the borders remain >>>> locked.

"Gord Dibben" wrote:

By default all cells on a sheet are locked when sheet is protected.

For Excel 2002 and newer versions.......................

Select the cells to type in.......presumably these cells have borders. >>>>>
Format>Cells>Protection. Uncheck the "Locked" option.

Tools>Protection>Protect Sheet>Allow users to:

Checkmark "select unlocked cells".

All other checkboxes remain cleared.

OK your way out.


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 13:36:01 -0800, cmcr34 <cmc...@discussions.microsoft.com>
wrote:

I want to create an exceel worksheet where the borders are protected from
copy/paste and drag/drop but the users can still type in data.

Thanks

Hi Gord,

My spreadsheet contains only thick borders. Every time I copy and paste data or text the borders change back to thin and I spend precious time redoing them back to thick. Very frustrating.

I have followed your instructions to the T but only got it right once. Seems like I can't lock the borders of the whole sheet.

Any ideas?

Thank you.

An alternative solution that is not that clean is to not use border but rather draw a colour inside a small cell. So you can insert a narrow column and fill it black to make it a border. But I agree it would be nice with the option to make the border

stay as it is almost always used to frame a certain area rather than a certain cell.

I am not aware of Macro limits but could one be written relative to new
input completion and have it apply an established cell style?

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

I am having this same issue
Gord recommended Format >cells > Protection

am I reading this wrong? Format has no cells options
and there is no protection menu.

I am using google sheets via my gmail.

I just want to lock all the formatting. I have a completed sheet that I have to readjust the borders every time I use it and its to the point I may as well be using a pen and paper.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Thursday, February 2, 2023 at 11:22:41 PM UTC, Jeremy Colli wrote:

I am having this same issue
Gord recommended Format >cells > Protection

am I reading this wrong? Format has no cells options
and there is no protection menu.

I am using google sheets via my gmail.

I just want to lock all the formatting. I have a completed sheet that I have to readjust the borders every time I use it and its to the point I may as well be using a pen and paper.

how to find google sheets id

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)