| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the last cell in a protected sheet
The command:
SpecialCells(xlLastCell).Select fails if my worksheet is protected. Is there any way round this without resorting to unprotecting the sheet (I don't want to have to hard code the password in my macro)? Thanks TM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cell color in protected sheet | Excel Worksheet Functions | |||
| how to paste a fomulae cell in a protected sheet | Excel Programming | |||
| finding the password to unlock a protected cell/chart | Charts and Charting in Excel | |||
| Can I allow cell merging in a protected sheet | Excel Worksheet Functions | |||
| Un-proteced Cell in a Protected Sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
