Share via

VBA Coding on a Shared Workbook - Possible?

Anonymous
2011-04-14T18:45:15+00:00

I currently have a VBA code written in Excel 2003 that will (1) Unprotect a sheet (2) Paste the user's domain, username, and a time stamp in a specified cell, and (3) Re-protect the sheet. This is basically being used as an "Electronic" signature. I am inquiring if anyone knows if it is possible to create a VBA code that will accomplish the same goals, however using the Protect and Share workbook function?

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

1 answer

Sort by: Most helpful
  1. Anonymous
    2011-04-14T23:09:57+00:00

    Macros cannot be viewed or edited in shared workbooks, but macros created in the workbook when it is not shared can be run when it is shared.  So I see no reason why your existing macro should not work

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments