+ Reply to Thread
Results 1 to 3 of 3

locking cells in a sheet when a workbook is saved

  1. #1
    Registered User
    Join Date
    12-16-2013
    Location
    uae
    MS-Off Ver
    Excel 2010
    Posts
    2

    locking cells in a sheet when a workbook is saved

    i'm a beginner in Vb, but i created a nice sheet and wanted to add this option to it it's a work book having 33 sheets,each sheet is password protected,what i want is when an employee goes to sheet 1,edit it and then save, certain range of cells will be locked so he'll not be able to edit again this has to come with a msg when he save, the file will be locked for editing, are you sure you want to proceed

    thanks for your help

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: locking cells in a sheet when a workbook is saved

    Make use of workbook before save event

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    12-16-2013
    Location
    uae
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: locking cells in a sheet when a workbook is saved

    well as i said i'm a little bet beginner in that, so what should be
    "your code here"
    the code to lock certain range when the file is saved
    sorry to bother you with that

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] locking cells in a workbook
    By jed38 in forum Excel General
    Replies: 2
    Last Post: 08-23-2012, 04:19 PM
  2. Locking all cells in a workbook
    By drgogo in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-15-2010, 11:37 AM
  3. Locking Sheet within Workbook VBA
    By Smee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-01-2009, 06:28 AM
  4. Locking single sheet in workbook
    By scottimus in forum Excel General
    Replies: 3
    Last Post: 04-29-2008, 02:31 PM
  5. Replies: 1
    Last Post: 07-21-2006, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1