• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

error 50289 project protected

A

amitc4u

Member
Hi,
I have a VBA code that I'dd like to protect and prevent users from viewing the code.
still, I want them to use and activate the code by clicking a button that operates the macro.
I protected the macro by using the 'VBAProject - Project properties' => 'Protection' tab.
the problem is that trying to operate the macro when the password was not entered creats the 'error 50289 project protected'.
appreciate the help.
Amit
 
Hi Amit ,

This error should be generated if the code that you are wanting to run is itself trying to change the project in any way.

If your code is doing that , there is no solution.

Can you confirm ?

Narayan
 
The code changes the project.
it creats a new sheet and place objects (text in a margined cells) according to data in a "main" sheet.
isn't there a way to operate the macro and also keeping it locked or hidden from users (privacy rights issues) ?
 
You must log in or register to reply here.
Back
Top