Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
is it possible to record a macro that would lock a sheet des-sa[_2_] Excel Discussion (Misc queries) 8 September 17th 08 10:41 AM
how do i write a macro to move down in the sheet one line ? surelystumped New Users to Excel 2 August 30th 06 06:44 PM
Referring to the previous selected sheet in a macro michaelberrier Excel Discussion (Misc queries) 2 June 12th 06 02:35 PM
macro to extract data of a selected sheet TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 February 27th 06 07:47 AM
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? Daniel Excel Worksheet Functions 1 June 24th 05 12:38 AM


All times are GMT +1. The time now is 03:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"