| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to apply a macro to a protected cell
|
|
#2
|
|||
|
|||
|
Hi
In Excel 2002/2003 when you protect your sheet you have some options. You can also protect your sheet with code like this all macros are working then (97-2003) Sub auto_open() With Worksheets("sheet1") .Protect Password:="ron", userinterfaceonly:=True End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "greensl" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert text in a cell with a macro | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Macro on cell content | New Users to Excel | |||
Linear Mode
