Unprotecting Worksheets in VB Script

  • Thread starter Thread starter InnerChild
  • Start date Start date
I

InnerChild

I am using this code to unprotect worksheets in a small program I have:

Sheets("Intropage").Unprotect "ugc"

I have since learned, that this does not work in Excel '97. Can anyon
help me out with the command that unprotects password protected sheet
in '97? Is it possible?

Thank
 
It will work in Excel 97.

If you are doing it from a commandbutton, change the TakefocusOnClick
property to false.
 
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

Protecting worksheet. 1
Copying in sheet with protection with the use of a macro 5
Macro can not unprotect a sheet in a shared workbook 4
Macro to prompt for password to unprotect worksheets 2
How to bypass password when pasting FROM a protected workbook 3
Xl2007 not unprotecting worksheet!!!! 1
Excel Protection 2
Unprotect Workbook with Function 3

Back
Top