Formatting and allow users to edit ranges (excel 2003)

M

mich879

Hi,

For an application, I want a group to be able to modify text and the
formatting of certain columns, while I want another group of users to be able
to change the formatting and text of the other columns.

For editing the content of the cells this works perfectly using
tools/protection/allow users to edit ranges.

However, this does not seem to affect their ability to change the formatting
of the cells. I can only allow all users or none to change the formatting of
all cells by selecting "format cells" checkmark when choosing
tools/protection/protect sheet.

Is there any way to do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allow users to edit ranges problem 2007 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Allow Users To Edit Ranges - Excel 2003 0
Preventing formatting changes in a protected worksheet 0
Enabling Autofilter and Sorting in a Protected Sheet 2
Lock format but allow data entry 1
Restrict editing but allow formatting 1
hide columns on a protected sheet??? 1

Top