Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: LOCKED EXCEL SHEET

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Our company has made an Engineering Change sheet and locked it. When someone accesses it, they are supposed to rename the file to the particular name per company standards.
    When just typing in the particular areas works fine, when someone tries to paste or insert a small picture (e.g. part of a drawing) they get the message "Microsoft Excel cannot paste the data"
    How can I get rid of this but still keep certain parts of the sheet protected

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hiya,

    I'm taking a wild guess here - but under Toolsprotectionprotect sheet do you have the Objects checked for protection? If so, can you get away with removing Object protection (I'm not sure how to unlock a specific object for example).

    Hope that helps somewhat,
    Adam

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    do you still need help?

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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