Thank you for your help..but I need part of the worksheet protected and
shared and the formatting toolbar need to be access by users.

"Jon Peltier" wrote:

Two things are preventing it: password protection, and workbook sharing. Remove both
of these constraints and you'll be able to format the sheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

saslimm wrote:

How can I access my formatting toolbar when part of my worksheet is password
protected, this is a share worksheet.