+ Reply to Thread
Results 1 to 2 of 2

Unable to post VBA linked data to protected worksheets

  1. #1
    Registered User
    Join Date
    02-20-2009
    Location
    Surrey
    MS-Off Ver
    Excel 2003
    Posts
    4

    Unable to post VBA linked data to protected worksheets

    I have six worksheets in one workbook the first worksheet (Appointments) is used as the primary input sheet and the remaining sheets get updated automatically with the following code

    Please Login or Register  to view this content.
    I wish to protect some fields on the five remaining worksheets from being over typed and thus have applied protection - however as these sheets are protected I am unable to edit the first worksheet. Can I modify the code above to allow update of protected cells or happy to consider another approach.

    Thanks Tony

  2. #2
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264

    Re: Unable to post VBA linked data to protected worksheets

    Hi Tony

    Personally I would use a different approach whereby the user clicks on an update button having entered data in Appointments and the code that this activates then updates the data to all other sheets. If you do it like this then you can have the code unprotect the specified sheets before copying the data in.

    If you want further direction on such an approach, please could you provide more details eg on wheredata might be entered into sheet Appointments and where it needs to get copied to in the other sheets.

    Richard
    Richard Schollar
    Microsoft MVP - Excel

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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