Posted to microsoft.public.excel.programming

Nauman Khan Nauman Khan is offline

external usenet poster

Posts: 1

Format as Table

Is it possible to autoprotect certain cells after a vaule has been entered so
it cannot be modified.
The cells to be protected after data is entered a
C2:E2 (merged)
I2
L2
N2
B4

Also, the Format as Table feature does not work in excel once Protect Sheet
& Protect and Share Workbook features with tracking are turned on(password
protected). Is there a way around this?

Any help will be much appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Table format	Steven	Excel Discussion (Misc queries)	1	September 10th 09 11:43 PM
Format Cells within a table	dpal	Excel Discussion (Misc queries)	2	June 16th 09 01:56 PM
format table	Naz	Excel Programming	3	September 12th 08 09:03 PM
table format	rcc	Excel Discussion (Misc queries)	1	July 18th 06 07:35 PM
Data in Cross-Tab format: needs to be written in Table Format	runyan	Excel Programming	2	October 4th 05 07:58 AM

All times are GMT +1. The time now is 03:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us