ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Write macro to lock selected sheet when run (https://www.excelbanter.com/excel-discussion-misc-queries/206254-write-macro-lock-selected-sheet-when-run.html)

office3000

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


Jim Thomlinson

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




All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com