Results 1 to 4 of 4

Locking cells except through Export through Userform

Threaded View

aaron.mendes Locking cells except through... 10-31-2013, 08:51 AM
jaslake Re: Locking cells except... 11-03-2013, 02:38 PM
aaron.mendes Re: Locking cells except... 11-04-2013, 07:11 AM
jaslake Re: Locking cells except... 11-04-2013, 09:53 AM
  1. #1
    Registered User
    Join Date
    07-01-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    66

    Locking cells except through Export through Userform

    Hi Experts,

    I have attached my Userform excel file. Had a question.
    I do not want any users to be able to edit the Commentary and Analysis worksheet tab. They should be able to edit it only by the Userform when they hit 'Export to Excel' button.

    Is it possible to lock the file in such a way?

    Thanks and Regards,
    Aaron Mendes
    Attached Files Attached Files
    Last edited by aaron.mendes; 11-04-2013 at 01:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Locking specific cells eventually changing to locking all cells
    By davidingilbert in forum Excel General
    Replies: 1
    Last Post: 03-19-2013, 06:50 PM
  2. Help with macro, automatical locking cells when excel is closed but only locking 1 sh
    By snoopy1461 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2011, 11:29 AM
  3. Need Protecting/locking of headers from overwrite by userform.
    By rocki in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2008, 06:52 PM
  4. Replies: 1
    Last Post: 07-21-2006, 11:05 AM
  5. [SOLVED] UserForm locking up
    By excelnut1954 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2006, 01:55 PM

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