ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent user from changing font color (Excel 2003) (https://www.excelbanter.com/excel-programming/430150-prevent-user-changing-font-color-excel-2003-a.html)

Maxx[_2_]

Prevent user from changing font color (Excel 2003)
 

How can I prevent the user from changing the font color?



Gord Dibben

Prevent user from changing font color (Excel 2003)
 

In what?

A cell or cells?

An entire worksheet?

An entire workbook?

Excel globally?


Gord Dibben MS Excel MVP

On Mon, 22 Jun 2009 07:24:27 +1000, "Maxx" wrote:

How can I prevent the user from changing the font color?



Maxx[_2_]

Prevent user from changing font color (Excel 2003)
 

In a range of cells.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
In what?

A cell or cells?

An entire worksheet?

An entire workbook?

Excel globally?


Gord Dibben MS Excel MVP

On Mon, 22 Jun 2009 07:24:27 +1000, "Maxx" wrote:

How can I prevent the user from changing the font color?





Gord Dibben

Prevent user from changing font color (Excel 2003)
 

Protect the worksheet and don't allow cell formatting.


Gord Dibben MS Excel MVP

On Tue, 23 Jun 2009 07:36:53 +1000, "Maxx" wrote:

In a range of cells.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
In what?

A cell or cells?

An entire worksheet?

An entire workbook?

Excel globally?


Gord Dibben MS Excel MVP

On Mon, 22 Jun 2009 07:24:27 +1000, "Maxx" wrote:

How can I prevent the user from changing the font color?





Maxx[_2_]

Prevent user from changing font color (Excel 2003)
 

Thank you for that.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Protect the worksheet and don't allow cell formatting.


Gord Dibben MS Excel MVP

On Tue, 23 Jun 2009 07:36:53 +1000, "Maxx" wrote:

In a range of cells.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
In what?

A cell or cells?

An entire worksheet?

An entire workbook?

Excel globally?


Gord Dibben MS Excel MVP

On Mon, 22 Jun 2009 07:24:27 +1000, "Maxx" wrote:

How can I prevent the user from changing the font color?








All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com