| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if worksheet is protected using code
Just wondering if theres a way i can do a simple "i
Worksheets("3.Data") is protected then" also how would i assign a value to a cell using code? i.e. say A1 "blah" ? it didnt like cells(a1)="blah" which i assumed would be th way. thank -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Check if Worksheet TAB is protected or Not | Excel Discussion (Misc queries) | |||
| Spell check when worksheet is protected | Excel Discussion (Misc queries) | |||
| unprotect check box in protected worksheet | Excel Discussion (Misc queries) | |||
| spell check for protected worksheet for Excel 97 | Excel Discussion (Misc queries) | |||
| Why doesn't spell check work on a protected worksheet? | Excel Worksheet Functions | |||
![neowok[_68_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
