Macro fails without VB help files

M

Michael Miazga

I have a couple macros in a worksheet. The first adds a picture and
protects the file. The second unprotects the file, adds a picture and
reprotects the file. On some machines, the second macro fails with the
error:

Run-time error '1004':

You cannot use this command on a protected sheet. To unprotect the sheet,
use the Unprotect Sheet command (Tools menu, Protection submenu). You may
be prompted for a password.

If I install the Microsoft Visual Basic Help files, the macro runs fine. It
will fail every time until I install the VB help files, after that it runs
perfect every time. Anyone have any idea what it installs that clears this
up?
 

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

Office add-in registration error - Component not correctly registered 0
Protected word template - vb/macro to update footer 7
macros to hide sheet with protection 1
Copying in sheet with protection with the use of a macro 5
Problem in adding macro to ribbon through Add-in 7
unprotect worksheet error 3
Sheet Protection doesn't hold 0
Multiple sheet unprotection not working 9

Top