Posted to microsoft.public.excel.programming

Robert[_16_] Robert[_16_] is offline

external usenet poster

Posts: 29

xlUnlocked Cells Not Working

I have a file where sheet 1 is protected but has two unlocked cells. I have
set in VBA browser the EnableSelection to xlUnlockedCells.

Returning to the spreadsheet, sheet 1 correctly only allows movement between
the two unlocked cells. However, if I close the file after saving, when
opened the xlUnlockedCells has been turned off.

Any ideas?

Thanks, Robert

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
Merging cells not working	Pierewiet	New Users to Excel	2	November 21st 08 04:38 PM
Working with pairs of cells	vsoler	Excel Worksheet Functions	15	June 18th 07 10:58 AM
SUMPRODUCT not working, some cells with #N/A	Ray	Excel Discussion (Misc queries)	3	June 14th 07 07:55 PM
Some Cells Not Working	KEVIN GUNN	Excel Discussion (Misc queries)	3	June 21st 05 09:47 PM
xlUnlocked cells?	Marc	Excel Discussion (Misc queries)	3	March 29th 05 07:49 PM

All times are GMT +1. The time now is 05:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us