| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EnableSelection for all sheets
Hi,
Can I amend the code below so that it applies to all worksheets without the need to list each sheet name? Sub Workbook_Open() Sheets("Sheet1").EnableSelection = xlUnlockedCells End Sub -- This post was created using recycled electrons! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
EnableSelection for all sheets
Use a looping macro
-- Don Guillett SalesAid Software "Newbeetle" wrote in message ... Hi, Can I amend the code below so that it applies to all worksheets without the need to list each sheet name? Sub Workbook_Open() Sheets("Sheet1").EnableSelection = xlUnlockedCells End Sub -- This post was created using recycled electrons! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
EnableSelection for all sheets
Try
Dim WS As Worksheet For Each WS In ThisWorkbook.Worksheets WS.EnableSelection = xlUnlockedCells Next WS -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Newbeetle" wrote in message ... Hi, Can I amend the code below so that it applies to all worksheets without the need to list each sheet name? Sub Workbook_Open() Sheets("Sheet1").EnableSelection = xlUnlockedCells End Sub -- This post was created using recycled electrons! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EnableSelection Protecting sheet question | Excel Discussion (Misc queries) | |||
| what is enableselection proprty does? | Excel Programming | |||
| EnableSelection = xlUnlockedCells | Excel Programming | |||
| Why does the EnableSelection-xlNoSelection stick thru the user interface? | Excel Programming | |||
| .EnableSelection = xlUnlockedCells | Excel Programming | |||
Linear Mode
