ExcelBanter - how do i restrict users from changing my formulas

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i restrict users from changing my formulas (https://www.excelbanter.com/excel-discussion-misc-queries/101758-how-do-i-restrict-users-changing-my-formulas.html)

Help with formulas

how do i restrict users from changing my formulas

VBA Noob

how do i restrict users from changing my formulas

Try protecting the sheet and format cells protection tab and hidden

VBA Noob

--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=565811

Gord Dibben

how do i restrict users from changing my formulas

Lock those cells and protect the worksheet.

Much more can be found under "protection" in Help section.

Gord Dibben MS Excel MVP

On Thu, 27 Jul 2006 14:31:01 -0700, Help with formulas <Help with
wrote:

All times are GMT +1. The time now is 05:16 PM.