ExcelBanter - Change font color in protected worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Change font color in protected worksheet (https://www.excelbanter.com/excel-worksheet-functions/166846-change-font-color-protected-worksheet.html)

Dyanna

Change font color in protected worksheet

I have a protected worksheet that I would like others to be able to change
font color - but not the information - can this be done?

OssieMac

Change font color in protected worksheet

Hi Dyanna,

When you protect with the password you have a number of options that you can
allow the user to do.

Check the boxes for 'Select locked cells' and also 'Format cells'.
--
Regards,

OssieMac

"Dyanna" wrote:

I have a protected worksheet that I would like others to be able to change
font color - but not the information - can this be done?

Dyanna

Change font color in protected worksheet

Got it - thanks!!

"OssieMac" wrote:

Hi Dyanna,

When you protect with the password you have a number of options that you can
allow the user to do.

Check the boxes for 'Select locked cells' and also 'Format cells'.
--
Regards,

OssieMac

"Dyanna" wrote:

I have a protected worksheet that I would like others to be able to change
font color - but not the information - can this be done?

All times are GMT +1. The time now is 04:27 PM.