best training excel vba - excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Thu 15 Nov 2007, 10:08Delegate Sharon said...

Sharon has attended:
No courses

Excel

How do you give a work book a password.

For upcoming training course dates see: Pricing & availability

replyReply Thu 15 Nov 2007, 11:06Trainer Pete said...

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:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard