| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Write macro to lock selected sheet when run
Hello, Is it possible to write a macro to lock a selected sheet for editing when run? Thanks in advance -- office3000 ------------------------------------------------------------------------ office3000's Profile: http://nettechguide.com/forums/member.php?u=393 View this thread: http://nettechguide.com/forums/showthread.php?t=2244965 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Write macro to lock selected sheet when run
Define lock. You can lock the cells and protect the sheet which will keep the
average user from being able to edit the information. There is nothing foolproof to keep the expert user from hacking into your sheet though... -- HTH... Jim Thomlinson "office3000" wrote: Hello, Is it possible to write a macro to lock a selected sheet for editing when run? Thanks in advance -- office3000 ------------------------------------------------------------------------ office3000's Profile: http://nettechguide.com/forums/member.php?u=393 View this thread: http://nettechguide.com/forums/showthread.php?t=2244965 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to record a macro that would lock a sheet | Excel Discussion (Misc queries) | |||
| how do i write a macro to move down in the sheet one line ? | New Users to Excel | |||
| Referring to the previous selected sheet in a macro | Excel Discussion (Misc queries) | |||
| macro to extract data of a selected sheet | Excel Discussion (Misc queries) | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Linear Mode
