Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Re: Help for Excel 95
From:	Mike McNeil Computer Troubleshooters Queenstown <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Wed, 14 May 2003 08:53:24 +1200
Content-Type:	text/plain
Parts/Attachments:	text/plain (36 lines)

I don't have Excel 95, but the solution should be similar as follows.

1. Select the cells in the sheet that you want to allow to be updated.
2. From the Format menu select Cells/Click the protection tab, and uncheck
the Locked Option.
3. From the tools Menu, Select Protection, and select protect Sheet.

Only the cells that you have previously marked as Unlocked can be edited,
all other cells in the sheet will be unavailable fir editing, so this should
resolve both of your issues.

Regards
Mike McNeil


Good day.

1)
I want to protect selected colomns and lines (not whole sheet) from writing
over that field. as for exemple Protecting Colomns A, B and C (whole
colomns) then the lines A59 to BB63 then at regular interval of lines A89 to
BB93, then A119 to BB123 etc...

2)
Also, while freezing a zone in sheet, that portion remain visiable all the
way but someone may modify the contents.

I wish to change such freezed portion in read only attribute.

Thanks for help
M. Kansara

                Curious about the people moderating your
                   messages? Visit our staff web site:
                    http://freepctech.com/staff.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG