sheet protection

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sheet protection

Sheet protection

resolvedResolved · Low Priority · Version 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:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips


Server loaded in 0.1 secs.