vba excel course london - protecting whole document

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba excel course london - Protecting a whole document

vba excel course london - Protecting a whole document

resolvedResolved · Low Priority · Version Standard

Rebecca has attended:
Excel Advanced course

Protecting a whole document

Can you also tell me how I can protect a workbook so users cannot delete it from the desktop?

RE: Protecting a whole document

Dear Rebecca

See if you can speak to the networking or technical support guy at your workplace.

I know that they can set separate privileges to various groups and users to give various rights and one of them does include deleting files or folders!!

I'll speak to the technical guys here @ Best training and see if they can suggest something!!

Hope this helps!!


 

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips


Server loaded in 0.08 secs.