repeated question: how to protect sheets from within VBA?

  • Thread starter Thread starter jon
  • Start date Start date
J

jon

I need to protect all of the sheets in my AddIn before I release it, but I
don't want them to be protected while I'm doing development. Is there any
way to protect the sheets when the AddIn is loaded, or at some other time?
I'm using Excel 97...

:)

Jon
 
Jon

Why don't you do your development, then protect the sheets, then save? You
could use the Workbook_Open event of the add-in, but it seems unnecessary.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to protect sheets from VBA? 1
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Sheet protection complications 4
Convert Excel VBA addin to a Protected Format 6
Chartobjects protected but it can still be deleted, edited and movedby the user (yes, the sheet is p 5
Protect workbook 1
Named Ranges vs. Constant Addresses, sheet protection, Guidance. 1
copying VBA from one Excel file to another 1

Back
Top