protection

[cpc]

Rerotect sheet and protect workbook. I want to be able to have my sheet protected and still have the user be able to hide rows.
Is this possible ?

 

[brettvba]

when you protect the sheet select in the cheq boxes "format rows"
and that ill do it
This message was edited by brettvba on 2002-04-30 17:07

 

[Yogi Anand]

On 2002-04-30 16:54, cpc wrote:
Rerotect sheet and protect workbook. I want to be able to have my sheet protected and still have the user be able to hide rows.
Is this possible ?

No ... cant' do!
You might be able to do through a macro -- by unprotecting the sheet just before allowing the user to hide rows and the turning the sheet protection back on.

Hope This Helps!

 

[cpc]

select format rows in the cheq box? Where
is that cheq box?

 

[Yogi Anand]

On 2002-04-30 17:06, brettvba wrote:
when you protect the sheet select in the cheq boxes "format rows"
and that ill do it
This message was edited by brettvba on 2002-04-30 17:07

Hi brettvba:
I need some help understanding this one. I am using Windows 98 and Excel 97. When I go to protect the Worksheet, I do not have access to any check boxes that would allow me to format rows.

Regards!

Yogi Anand

 

[cpc]

On 2002-04-30 17:06, brettvba wrote:
when you protect the sheet select in the cheq boxes "format rows"
and that ill do it
This message was edited by brettvba on 2002-04-30 17:07

Brettvba: Select format rows cheq box, ? Where is that cheq box?

 

[brettvba]

goto Tools,Protection,Protect Sheet
Then the box pops up to enter a password etc
and under the text
"Allow all users of this worksheet to"
Fifth cheqbox down is Format Rows

although im not sure if this is a new feature in xp (thats the ver im using)
so it may not be there not sure on that one.

 

[Yogi Anand]

On 2002-04-30 17:17, brettvba wrote:
goto Tools,Protection,Protect Sheet
Then the box pops up to enter a password etc
and under the text
"Allow all users of this worksheet to"
Fifth cheqbox down is Format Rows

although im not sure if this is a new feature in xp (thats the ver im using)
so it may not be there not sure on that one.

T H A N K S !

Regards

Yogi Anand

 

[brettvba]

NO WORRIES YOGI

 

[cpc]

On 2002-04-30 17:17, brettvba wrote:
goto Tools,Protection,Protect Sheet
Then the box pops up to enter a password etc
and under the text
"Allow all users of this worksheet to"
Fifth cheqbox down is Format Rows

although im not sure if this is a new feature in xp (thats the ver im using)
so it may not be there not sure on that one.

brettvba,

Thanks alot.
cpc
This message was edited by cpc on 2002-04-30 18:27