Results 1 to 6 of 6

transferring data to a protected sheet

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2013
    Location
    Stdney,Australia
    MS-Off Ver
    Excel 2013
    Posts
    3

    transferring data to a protected sheet

    Hi

    I have a workbook which when closed makes all sheets protected. I want to be able to transfer data from Weekly Graph sheet to the Score sheet while the Score sheet is in the protected mode. If I un-protect Score Sheet first and then transfer data it works fine but if I have the Score Sheet protected it gives an error.
    need to be able to transfer data from Weekly Graph sheet to a protected sheet called Score

    Also when the workbook is closed it changes the caption on the Weekly Graph sheet commandbutton to Unprotect Sheet.How do I change the code so that on the Score sheet it also says Unprotect Sheet when workbook closed.So when I open up the workbook both buttons always say Unprotect Work Sheet (weekly Graph and Score)

    Thank you

    Paul
    Attached Files Attached Files

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