formatting when sheet protected ?

tumbler

New Member
Joined
Jun 17, 2003
Messages
35
If a cell is unlocked, but the sheet protected, the contents of the cell can be altered, but all formatting commands are not available ? is there a way around this, so that formatting (cell colouring) can be achieved ?
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

andre5

Board Regular
Joined
Aug 11, 2005
Messages
108
When you protect your sheet tick the format boxes to enable it after it is protected.

or if the protection is done via VB
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True

Hope that helps
 

tumbler

New Member
Joined
Jun 17, 2003
Messages
35
sorry - not sure what you mean by "tick the format boxes" ? i'm on excel 2000
 

andre5

Board Regular
Joined
Aug 11, 2005
Messages
108
try to protect it via VB then. In Excell 2003 you have an option when protecting a sheet to allow formating
 

tumbler

New Member
Joined
Jun 17, 2003
Messages
35
and ....

.... so how do I use the VB code to protect the sheet ! (sorry) I guess I copy the code you put up, but when I put it into the VBA project / workbook, nothing changes ?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,820
Messages
5,574,508
Members
412,599
Latest member
Schu94
Top