mikerickson mikerickson is offline

Junior Member

Location: Winters CA

Posts: 22

Have you used the EnableSelection property? It allows you to control the selection behaviour of a protected worksheet

Code:

Worksheets("sheet1").EnableSelection = xlNoSelection

xlNoRestrictions and xlUnlockedCells are the other choices.

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
call excelsheet within excelsheet when user clicks excelsheet ico	mohini	Excel Worksheet Functions	0	November 20th 06 05:07 AM
How can user move in locked worksheet but not copy cell contents?	PAT	Excel Worksheet Functions	0	April 25th 06 08:40 PM
Locked by User	donnaK	Excel Discussion (Misc queries)	3	February 8th 06 02:38 PM
Open an Outlook folder when a user clicks on a command button ...	Rob Keel	Excel Discussion (Misc queries)	2	August 1st 05 08:23 AM
excel locked by another user=myself	bbxrider	Setting up and Configuration of Excel	3	April 29th 05 08:10 PM

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

About Us

"It's about Microsoft Excel"