Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - Opening an excel document as read only

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel vba courses london - Opening an excel document as read only

Resolved · Low Priority · Version Standard

Reply Fri 10 Aug 2007, 11:53Delegate Anthony said...

Anthony has attended:
Excel Advanced course

Opening an excel document as read only

When right clicking on an excel document from the open window the option to open a file as read only is sometimes present. If not how can a file be opened as read only so other users can open the file after you as the main user?

For upcoming training course dates see: Pricing & availability

Reply Fri 10 Aug 2007, 13:37Trainer Alan said...

RE: Opening an excel document as read only

Hi Anthony

When you use the File Open dialog there is a drop down arrow next to the OPEN button. Click the arrow and choose the read only option.

Cheers!

Alan

Excel articles

· How To Link Between Spreadsheets In Excel
· Find Out How To Create That Missing Link With Excel
· Discover The PMT, IPMT And PPMT Functions In Excel
· Importing Useful Information From The Web To Excel
· Want To Get To Grips With The Different SUM Functions In Excel?

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips