protect shape from editing

Anonymous
2014-02-04T07:16:06+00:00

I want to protect shape for my macro enable workbook

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

6 answers

Sort by: Newest
  1. Anonymous
    2014-02-04T16:32:17+00:00

    Thanks sir. In the  the following code The code should overwrite data if already exist. But I want add data next to existing one by adding comma. Into following bold REG sheeet. E.g though data already in V U T columns write next to it. Please suggest solution for changing the follwing code.

        If I enter No. in F7 in LC  data is updating in LC sheet from REG sheet. And when print LC sheet the data from LC record  in REG sheet. But in REG data is overwriting in V U T columns and instead of happening  so I want to add data next if already exist by adding comma.

    http://sdrv.ms/LKuBil

    Was this answer helpful?

    0 comments No comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  3. Anonymous
    2014-02-04T12:37:45+00:00

    when i try to print sheet then 'application defined or object defined error took place'

    when the sheet is protected some cells are not protected in LC sheet, please reply.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2014-02-04T09:40:58+00:00

    It will not make any difference whether your sheet is macro enabled or not. It should work.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2014-02-04T09:30:50+00:00

    Thanks, but tell if it is helpful in macro enabled sheet Here the link-

    http://sdrv.ms/LKuBil

    Was this answer helpful?

    0 comments No comments