Disallow cell data entry which autopopulates

Posted to microsoft.public.excel.worksheet.functions

jackel[_10_] jackel[_10_] is offline

external usenet poster

Posts: 1

Disallow cell data entry which autopopulates

I have a macro which autopopulates a date/time stamp (lets say,cell B1)
when a selection is chosen in (A1). This time stamp can be changed and
I don't want anyone to be able to change it. I want to make the cell
where the user can click the cell, but when they try to type, nothing
happens.

Thanks,

--
jackel

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Cell Entry That Locks Selected Cells From Any Data Entry.	ron	Excel Worksheet Functions	5	February 16th 07 09:52 PM
How do I get data validation to disallow specific entries	a-one-and-a-two	Excel Worksheet Functions	10	January 5th 07 10:52 PM
Data entry - Copy contents of cell typed in one cell to another ce	danie	Excel Worksheet Functions	2	March 16th 06 06:51 PM
Disallow cell entries	hopeace	Excel Discussion (Misc queries)	3	October 14th 05 12:19 AM
In Excel, how can I tell the program to disallow duplicate data i.	gthawkster	Excel Worksheet Functions	5	December 15th 04 04:42 AM

All times are GMT +1. The time now is 07:55 AM.

Menu

About Us