My apologies to viewers who have read this post already. I forgot to put a title on my last post.
As part of a
string of answers to a previous question (see “Why do I encounter problems running macros in a shared workbook?”), I’m left
with the impression that I cannot successfully run macros in a shared workbook if I protect worksheets/workbooks. The reason
I’d like to have worksheet protection is that I have many data forms set up and there are some data forms where I do not want
users entering or editing existing data fields (sheet protection grays out the cells and the “New” button”). If anyone has
successfully protected and unprotected a sheet using a macro in a shared workbook, I’d love to hear about it. I’ve tried
setting up some very simple examples and have not been able to get them to work.
I read the Excel help menu on the
limitations of workbooks and it does not say that you cannot use protection features on shared workbooks
help menu) In a shared workbook, you cannot do the following:
· Assign a password to protect individual worksheets or the entire workbook. Protection that you applied before sharing the
workbook remains in effect after you share the workbook.
· Change or remove passwords. Passwords that you assigned before sharing the workbook remain in effect after you share the
Write, change, view, record, or assign macros. However, you can record operations in a shared workbook into a macro stored in
another workbook that isn't shared. In a shared workbook, you can run macros that were created before you shared the
workbook; although if you run a macro that includes an unavailable operation, the macro stops running when it reaches the