Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

sheet protection

ResolvedVersion Standard

Jeremy has attended:
Excel Intermediate course

Sheet protection

How to protect the same criteria (formulas) across multiple sheets?

RE: Sheet protection


Thankyou for attending the course on Tuesday, i hope you really enjoyed it.

The answer to you question is as follows: there are two ways to make your sheets protected so that multiple one are protected i would reconmend you use this one

when you go to file, save as. From the window that comes up go to the top right of the window and choose tools, then click general options, then put in a password to open and a password to modify which should do the trick, you will need to enter (both passwords twice).

This will then prompt other users to input apassword to open and another to modify so if they get in to the file and try to change things they will need to input another password, PS make the 2 p.words different

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.