best training excel vba - excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » best training excel vba - Excel

best training excel vba - Excel

resolvedResolved · Low Priority · Version Standard

Sharon has attended:
No courses

Excel

How do you give a work book a password.

RE: Excel

Hi Sharon, Thank your for your post, to set a Password on a Workbook follow these steps; to add Password protection choose Tools, Protection from the Menu bar and select either Worksheet or Workbook. Provide and confirm your password.
Another method to provide Workbook protection is to use the File, Save As command and from the Save dialog box choose the drop down option next to the Tools menu at the top of the box, from the menu that opens choose General Options and provide a password where indicated. Hope that helps, regards Pete.


 

Excel tip:

Removing custom dictionary entries

If you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there.

View all Excel hints and tips


Server loaded in 0.14 secs.