#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Protecting sheet

Morning all,

I'm trying to understand the purpose of the "Allow all users of this
worksheet to:" in the protect sheet menu. It implies that a worksheet can
be protected in a granular fashion. For example I could allow the user to
insert columns, add data, format rows, but not delete columns or rows. When
I try selecting these options and then save the sheet, i'm always prompted
to unprotect before any data can be entered.

I'm trying to understand the purpose of the "Allow all users of this
worksheet to:" check boxes. If it's necessary to unprotect before data can
be added, it's unclear what function these check boxes assume.

Any help is appreciated.

Thanks

Art



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default Protecting sheet

Hi Art,
Go to the excel help and enter protect sheet, it will give you and excellent
explanation

"Art Cummings" wrote:

Morning all,

I'm trying to understand the purpose of the "Allow all users of this
worksheet to:" in the protect sheet menu. It implies that a worksheet can
be protected in a granular fashion. For example I could allow the user to
insert columns, add data, format rows, but not delete columns or rows. When
I try selecting these options and then save the sheet, i'm always prompted
to unprotect before any data can be entered.

I'm trying to understand the purpose of the "Allow all users of this
worksheet to:" check boxes. If it's necessary to unprotect before data can
be added, it's unclear what function these check boxes assume.

Any help is appreciated.

Thanks

Art




  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Protecting sheet

Thanks Eduardo,

I had read the on-line help and many google post but did not find an
explanation.

Art
"Eduardo" wrote in message
...
Hi Art,
Go to the excel help and enter protect sheet, it will give you and
excellent
explanation

"Art Cummings" wrote:

Morning all,

I'm trying to understand the purpose of the "Allow all users of this
worksheet to:" in the protect sheet menu. It implies that a worksheet
can
be protected in a granular fashion. For example I could allow the user
to
insert columns, add data, format rows, but not delete columns or rows.
When
I try selecting these options and then save the sheet, i'm always
prompted
to unprotect before any data can be entered.

I'm trying to understand the purpose of the "Allow all users of this
worksheet to:" check boxes. If it's necessary to unprotect before data
can
be added, it's unclear what function these check boxes assume.

Any help is appreciated.

Thanks

Art






  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Protecting sheet

You have an active thread at one of your other posts.

Art Cummings wrote:

Morning all,

I'm trying to understand the purpose of the "Allow all users of this
worksheet to:" in the protect sheet menu. It implies that a worksheet can
be protected in a granular fashion. For example I could allow the user to
insert columns, add data, format rows, but not delete columns or rows. When
I try selecting these options and then save the sheet, i'm always prompted
to unprotect before any data can be entered.

I'm trying to understand the purpose of the "Allow all users of this
worksheet to:" check boxes. If it's necessary to unprotect before data can
be added, it's unclear what function these check boxes assume.

Any help is appreciated.

Thanks

Art


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
protecting a sheet des-sa[_2_] Excel Discussion (Misc queries) 3 January 15th 09 08:53 PM
Protecting a sheet and still allow some features [email protected] Excel Discussion (Misc queries) 0 June 26th 06 01:05 PM
Can't use tab after protecting sheet. tonyia Excel Worksheet Functions 0 March 21st 06 03:57 PM
Protecting Sheet purplerayn Excel Worksheet Functions 1 October 21st 05 12:55 AM
Can't use tab after protecting sheet. snam Excel Discussion (Misc queries) 3 January 21st 05 02:54 PM


All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"